Using VS 2005 and have a tableadapter, the adapter returns values based on a control paramter passed from a textbox, i want to pass a wildcard paramter, how can i do this, im basically looking for all values where the lastname like value%
code:
SELECT USERID, FIRSTNAME, LASTNAME
FROM TBLUSER
WHERE (LASTNAME LIKE :Last)

__________________
Thank You