how do you do a wildcard in an sql statement
eg
select * form my_table where username='(something)smith'
how do i do the (something) bit??
Printable View
how do you do a wildcard in an sql statement
eg
select * form my_table where username='(something)smith'
how do i do the (something) bit??
Depending on whether its for Sql Server or access or something :
Select * from tablename where [Thingy] like 'a*';
Select * from tablename where [Thingy] like 'a%';
Regards
Vince
cheers!