Helpful Information
 
 
Category: Other Databases
Like function in Access

I am trying to search for a particular string in access table. somehow Like '%%' is not returning any rows, which is incorrect. Any suggestions.. I am new to Access but I have used Oracle and SQL Server.
Also the same problem with NVL that fails in Access, what is the replacement function in Access for NVL.

Thanks in Advance,
Sunita...

What type of field are you searching in Access, string, int other...
In Access 2002 you use the * not the %

Select TableName.FieldName
From TableName
Where TableName.FieldName Like "*foo*";


As for the null stuff...

Select TableName.FieldName
From TableName
Where TableName.FieldName Is Not Null;










privacy (GDPR)