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

mu*******@msn.com
"Tammy B" <qu*******@plumbbob32domain.com> wrote in message
news:5M********************@comcast.com...

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