does the Access Procedure not support the like SQLStatement
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 ?
leonid 0Posted Mar 14, 2005, 3:15 AM