Vb6 Database

Is there anyway to look at a database record and check if a word is located in that column for example a login script which will check if the textbox contains the any username which is listed in the database under username and check the corasponding password be side it

 

Anyone?

 

Select [TableName].[Password] from [TableName] Where [TableName].[UserName] = @UserNameParam

are you talking about something like that?