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, 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
>
hello manish
why you want to use both LIKE and IN.you can use both in one operation
but according me it was not provide benifit.
and in you query----
Select tempid From temp Where tempname IN ('ttt%','sdsd%','%sdfs%')
is wrong with IN we use only value like this=---
Select tempid From temp Where tempname IN ('ttt','sdsd','sdfs')
may this helpful for you
regard
shikha chaurasia
--
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
