I am using
- 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?