<div>
<div class="content wysiwyg-content">
I am using <br />
- MSAccess<br />
- Microsoft SQL Server &nbsp;2000 - 8.00.760 (Intel X86)<br />
- FrontPage 2003<br />
<br />
I am trying to pull a report for a list of titles that being with a number 0-9. I have the following code working for an alphabet search:<br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;WHERE BookTitle LIKE 'B%' and ACTIVE LIKE 'Yes' &quot;<br />
<br />
Do I have to do an OR statement for each number or is there a an inclusive code?<br />
<br />

</div>
</div>


I am using 
- MSAccess
- Microsoft SQL Server  2000 - 8.00.760 (Intel X86)
- FrontPage 2003

I am trying to pull a report for a list of titles that being with a number 0-9. I have the following code working for an alphabet search:

	"WHERE BookTitle LIKE 'B%' and ACTIVE LIKE 'Yes' "

Do I have to do an OR statement for each number or is there a an inclusive code?



SQL WHERE field LIKE any number

I am using 
- MSAccess
- Microsoft SQL Server  2000 - 8.00.760 (Intel X86)
- FrontPage 2003

I am trying to pull a report for a list of titles that being with a number 0-9. I have the following code working for an alphabet search:

	&amp;quot;WHERE BookTitle LIKE &amp;#39;B%&amp;#39; and ACTIVE LIKE &amp;#39;Yes&amp;#39; &amp;quot;

Do I have to do an OR statement for each number or is there a an inclusive code?



Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

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.