Quote Originally Posted by daljitsb
You can use 'like' function
Select * from table where mycol like '%214%';

-D
I know that I can use it, but that's not the way out and besides you have to combine "mycol like '214%' or mycol like '%214' or mycol like '%,214,%'or mycol = '214'"
tahnks anyway