How do I look for the '#' inside a database field in the where part of my SQL statement? <BR><BR>I just need records that have the # sign.<BR>Thanks
instr() function will do it.
where PATINDEX('%#%', columnName) > 0<BR><BR>?<BR><BR>cp
since when is there an inStr() function in SQL?
Well it is an access database will is still work?<BR><BR>Like this <BR><BR>"Select fieldname from Tablename where instr(fieldname, '#')"<BR>
I didnt think you could do that???
i use it all the time in Oracle, i GUESSED it was there in SQL Server :-)