Querying the Pound Sign (#) 1

[sawilliams]

I know that the # sign is a special character but is there any way to query it? I'm trying to pull all records with a "#" in it.

 

[traingamer]

 ...WHERE (((OrderDetail.ItemNo) Like "*[#]*"));

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[sawilliams]

traingamer:

Wow, so easy... only if you know the secret. Such a simple thing will be invaluable to me.

Thanks!