gridview select command question

[Tammy B]

Hi!

I have the following select command:
SelectCommand="SELECT [id], [Name], [Address1], [Address2], [CITY], [STATE],
[ZIP], [COUNTRY] from [MyTable] WHERE ([Address1] = @txtAddress1)"

I would like to be able to use a LIKE operator rather than EQUALS

I can't figure it.

Can you help?

THANKS!!!!

 

[Munawar Hussain]

Hi,
you can use

SelectCommand="SELECT [id], [Name], [Address1], [Address2], [CITY], [STATE],
[ZIP], [COUNTRY] from [MyTable] WHERE ([Address1] LIKE '%' + @txtAddress1
+'%' )"

It would work fine...

Best wishes
Munawar Hussain

(e-mail address removed)