regular expression sql question

My system is about directory

I managed to query according to which 2 alphabetic user select.

sql = "Select * FROM customer WHERE companyname LIKE '" & strAlpha1 & "%' "
sql = sql & "OR companyname LIKE '" & strAlpha2 & "%' "
sql = sql & "ORDER BY companyname"
But the problem I face is those companys which are not start with alphabetic like 333 Sdn Bhd, _3COM Limited or etc. I know I can use NOT LIKE but anyway other way besides that because if I use NOT LIKE one by one like:

sql = "Select * FROM customer WHERE companyname NOT LIKE 'A%' "
sql = sql & "OR companyname NOT LIKE 'B%' "
sql = sql & "ORDER BY companyname"

Then I need to repeat it for 26 times since there are 26 alphabetic.

Thanks.

That assumes you use SQL Server, I'm not sure about Access as I rarely use it.

ljamal wrote: That assumes you use SQL Server, I'm not sure about Access as I rarely use it.

As I said above ...
Your error means that the ASCII function is not supported in Access. But since you didn't look it up I guess, I will for you....


The ASCII function in Access is ASC, if you replace ASCII with ASC in the SQL statement above it should work for you. I even tested it with the ASC function in Access, so it does work.

In the future if you are not willing to do the extra legwork when someone points you in the right direction, just hire someone to do it for you.