You can write your script like
Select tempid From temp Where ( tempname like 'ttt%' or tempname like
'sdsd%' or tempname like '%sdfs%' )
And tempname In (Select tempname From temp Where tempname like IN
('ttt','sdsd','dfs'))
धन्यवाद और सादर
विनीत कुमार श्रीवास्तव
Schenker Logistic Gurgaon
On Mon, Sep 19, 2011 at 9:06 PM, sumit tanwar <[email protected]>wrote:
> yes it is possible
>
> On 9/16/11, 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 <http://vb.net/>, C# .NET,
> > ADO.NET<http://ado.net/>,
> ASP.NET <http://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 :-->
> Sumit Tanwar
> 93120-31316
> Software Engineer
> Createch Software Pvt. Ltd.-New Delhi
>
> --
> You received this message because you are subscribed to the Google
> Groups "DotNetDevelopment, VB.NET <http://vb.net/>, C# .NET,
> ADO.NET<http://ado.net/>,
> ASP.NET <http://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
