Querying for an astricks

[RevDocJeff]

Is there a way of querying for an astricks? Some data in one of my tables has data that looks like this "A*" or "B*" or "C*", but most of the records are just "A" or "B" or "C"...I just need a query that I can pull out those records. Is there a way of doing this in a query?

Thanks

 

[pdx_man]

Use brackets around the asterisk:

"a[*]"