How to query the first 2 Characters of a Field

[Guest]

Good Morning;
I am running a query against an Oracle table and only want to select
anything that starts with "ZW" I have tried the "like" option and this did
not work.

Any help would be appreciated

Thanks

Chomp

 

[Guest]

Like ZW*

Dont forget the asterix

Hope this helps

 

[Douglas J. Steele]

Don't forget the quotes too! <g>

Like "ZW*"

or

Like 'ZW*'

Remember, as well, that if you're using ADO, the wild card is %, not *:

Like "ZW%"

or

Like 'ZW%'

 

[Guest]

Thanks very much..... worked like a charm

Chomp

Don't forget the quotes too! <g>

Like "ZW*"

or

Like 'ZW*'

Remember, as well, that if you're using ADO, the wild card is %, not *:

Like "ZW%"

or

Like 'ZW%'