Wild card in selection range

[back2tek]

Hi all,
Using Cr9 on SQL. I am trying to filter the records selected using a formula like:

({name} >="ABC123TOR" and {name}<="ABC999TOR")

I need to use a wild card in the selection formula,
like
({name} >="AB*123TOR" and {name}<="AB*999TOR")

How can this be achieved ?

Thank you for your thoughts,
BT

 

[Madawc]

You're asking it to sort ABZ1 ahead of ABA9, I can't see how it could.

What you could do is select on portions of the field. Try using Left({your.field}, 2) and MID({your.field}, 4, 6) as separate selections.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[back2tek]

Thank you