You can use like this :-
select * from sh1 where LAST_Name like 'SI%' OR LAST_NAME LIKE 'RY%' or
LAST_NAME IN ('BUTLER','STEWART')
Regards,
Arun Kumar
[email protected]
:+91-9811539923
________________________________
From: Pawan Rai <[email protected]>
To: [email protected]
Sent: Monday, 19 September 2011 4:15 AM
Subject: Re: [DotNetDevelopment] urgent help for Sql
you can use the following query instead:
Select tempid From temp Where tempname like 'ttt%' or tempname like 'sdsd%' or
tempname like '%sdfs%'
check this link out:
http://forums.devx.com/showthread.php?t=171540
Regards
Pawan Rai
On Fri, Sep 16, 2011 at 6:52 PM, MANISH LANGA <[email protected]> wrote:
hello ,
>
>
>
>I need to use IN and Like keywork in same opration in sql query. is it
>possible
>
>
>ex : Select tempid From temp Where tempname IN ('ttt%','sdsd%','%sdfs%')
> or
> Select tempid From temp Where tempname like IN ('ttt%','sdsd%','%sdfs%')
>
>
>please suggest ...
>
>
>Thanks
>Manish langa
>
>
>
--
>You received this message because you are subscribed to the Google
>Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML
>Web Services,.NET Remoting" group.
>To post to this group, send email to [email protected]
>To unsubscribe from this group, send email to
>[email protected]
>For more options, visit this group at
>http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en
>or visit the group website at http://megasolutions.net
>
--
Regards
Pawan Rai
Sr. Software Engineer
NIIT Technologies
Tel : +91 9818607165 (Delhi) | +91 9416394013 (Ambala)
--
You received this message because you are subscribed to the Google
Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML
Web Services,.NET Remoting" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en
or visit the group website at http://megasolutions.net
--
You received this message because you are subscribed to the Google
Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML
Web Services,.NET Remoting" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en
or visit the group website at http://megasolutions.net
