>-----Original Message-----
>From: VenuGopal Papasani [mailto:venu.papasani@stripped]
>Sent: Monday, March 13, 2006 11:48
>To: Jeff
>Subject: Re: Help regarding a simple query
>
>
>Hi Jeff,
> This is venu again.Last mail i did not include a constraint that is
what irritating me most.Actually if i got venu-kkk
> I should not get that venu-kkk.
> This was the query actually i want.
>
> Can you please give me teh query for that
>
>Regards,
>venu.
>
Please post all responses to the mailing list, not directly to another
person.
the "%" is a wild card character
Name
----------
Venu
VENU
XVENU
yVeNu
Venuzztest
select * from X where Name like '%venu%'
returns:
Venu
VENU
XVENU
yVeNu
Venuzztest
select * from X where Name like 'venu%'
returns:
Venu
VENU
Venuzztest
select * from X where Name like '%venu'
returns:
Venu
VENU
XVENU
yVeNu
Jeff
