hello

if got a query which has a field with numbers like "1/7807" and "S095/21"

i need a code that will say iff part table has "/" then 2 if not 1

please can anyone help

it needs to detect the "/"

thanks

regards raj

(you will need to change the "tblYourTableName" and "YourFieldName"(s) to the appropriate names of your table and field.)

SQL:-

SELECT tblYourTableName.YourFieldName, IIf(InStr(1,[YourFieldName],"/",1)>0,2,1) AS Slash
FROM tblYourTableName;

cheers john

that work like a charm

nice one