easy one(resolved)

[progressive]

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??

[Ecniv]

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

[progressive]

cheers!