Search field for specific Character

[kdoran]

I am trying to search a field with a query and want the criteria to find a single character and I am not sure how to find a character that may not always be in the same spot.

Example

Looking for V

FIV-18001
TV-18050

I am using this query for a report.

Any ideas,

Kelly

 

[coco86]

you can set the criteria to

like "*v*"

 

[scriverb]

Use the following SQL as a guide to setup a query for your table and fields:

Select *
FROM tblYourTable
WHERE (((Instr(1, tblYourTable.FieldName, "V&quot)>0));

Good luck. Bob Scriver

 

[kdoran]

Thank you both for your help.

Kelly