<div>
<div class="content wysiwyg-content">
I was wondering if anyone could help me with an SQL call. &nbsp;A user is going to input a zip code, let's say 44236. &nbsp;I need a call that will look for an exact match if no match then find the closest match. &nbsp;So if 44255 is in the data base the data on that number (44255) will be displayed.<br />
<br />
TIA
</div>
</div>


I was wondering if anyone could help me with an SQL call.  A user is going to input a zip code, let's say 44236.  I need a call that will look for an exact match if no match then find the closest match.  So if 44255 is in the data base the data on that number (44255) will be displayed.

TIA

search

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.