<div>
<div class="content wysiwyg-content">
We have Canada postcodes in our SQL Server database with start and end range like (for example):<br />
<br />
A0A1A0-A8A3P7<br />
B0A1A0-B9A3V6<br />
C0A1A0-C1N6W2<br />
E0A1A0-E9H2C8<br />
G0A1A0-G0A4Z0<br />
G0B1A0-G0E2J0<br />
G0G1A0-G0H1T0<br />
G0J1A0-G0L4K0<br />
<br />
How can we detect our customer postcode within the range using sql query or asp functions - please?<br />

</div>
</div>


We have Canada postcodes in our SQL Server database with start and end range like (for example):

A0A1A0-A8A3P7
B0A1A0-B9A3V6
C0A1A0-C1N6W2
E0A1A0-E9H2C8
G0A1A0-G0A4Z0
G0B1A0-G0E2J0
G0G1A0-G0H1T0
G0J1A0-G0L4K0

How can we detect our customer postcode within the range using sql query or asp functions - please?


Postcode range question

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.

Programming

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.