does the Access Procedure not support the like SQLStatement

Feb 22 2005 5:03 AM
Hi, i want to ask a question of Access Procedure (name:sp_User_GetUsersWithParams1): PARAMETERS [@keyword] Text ( 255 ), [@index] Text ( 255 ); SELECT * FROM [User] WHERE name like ' % [@keyword] % ' and letter=[@index] ORDER BY name; table field struct : [name]type text,[letter] type text (@index is a single letter like 'A') when i directorily run in the Database(communite.mdb),but it does not return any results that I want ! does the Access Procedure not support the like SQLStatement ? or something wrong have i maked ?

Answers (1)