PDA

View Full Version : Like function in Access



sunita_wagh
Feb 26th, 2005, 02:12 AM
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...

Darknight
Feb 26th, 2005, 06:29 AM
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;