datatable.select problem.

[chebbi]

Hi all

I have to run a sql query which looks like
select * from name where name like '[0-9]%'

This works fine in query analyser and returns me all names starting with numerical charater but if i put it in datatable.select as below i get the error

"The string pattern is invalid '[0-9]%'.

My code:

datatable.select( "Name like '[0-9]%'" ).

I also tried
datatable.select( "Name like '[0-9][%]'" ) to escape % but with same error message as result.

Can anyone let me know how to use brackets inside of select statement?

Thanks
Badrinath Chebbi

Badrinath Chebbi

http://www.bmchebbi.com

 

[ca8msm]

How about using something like:

datatable.Select("SUBSTRING(Name,1,1) IN (0,1,2,3,4,5,6,7,8,9,0)")

____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.