Like Operator with Wildcard 1

[demoman]

I cannot get the following to work...

Select * from <table> where <column> like 'a*'

Can someone tell me what the functional equivalency is?

I am using the Timberline pervasive driver

Thanks

 

[Linda84]

If you're using Pervasive.SQL 2000i, try:

Select * from <table> where <column> like 'a%'

For a LIKE operator, use % for any number of characters, and _ for single characters. Linda
Pervasive Software Support

 

[demoman]

Yes, this worked. Thanks, Linda!