Like function in Access

[sunita_wagh]

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]

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;