Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New to the CF scene
    Join Date
    Feb 2005
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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...

  • #2
    New Coder
    Join Date
    Nov 2002
    Posts
    87
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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;
    Last edited by Darknight; 02-26-2005 at 05:51 AM.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •