Select tempid from temp where tempname in ( select tempname from temp where
tempname like ''ttt%','sdsd%','%sdfs%'' )
but its same as
select tempname from temp where tempname like ''ttt%','sdsd%','%sdfs%''
On , 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
--
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
