The following query works...
Select * from [Sometable] where color Like 'Yello%'
(Returns all records with colrs = Yellow)
This query does not work and I need to be able to use single character wildcard.
Select * from [Sometable] where color Like 'Yello_'
Any Idea why the underscore is not returning any records
Any help is GREATLY appreciated!