SQL Query

[uspatel]

How to fetch records as OTH IA LE from table using Like query without using OR.as select *from Issue where ReqControlNo like '%i%' or ReqControlNo like '%h%' or ReqControlNo like '%l%' query should be as select *from Issue where ReqControlNo like 'condition' the condition should be in one string. is there any solution please?

[Luc Pattyn]

That's a task for the Union. :)

Luc Pattyn [My Articles] Nil Volentibus Arduum

[PIEBALDconsult]

Is this SQL server? Recently I wrote a CLR Scalar Function that uses RegEx to do that, that might be the sort of thing you need. I doubt it's easily doable with straight SQL.

[Lost User]

Uma Shankar Patel wrote:

the condition should be in one string.

Could you explain that? To me, the conditional filter is the entire WHERE clause. Are you by any chance looking for the full-text search[^]?

Bastard Programmer from Hell :suss:

[uspatel]

yes. it is Sql Server. Actually ,I want to search those records that have i ,l or h. I want put the string in database.as %comm% for Records that have comm. %crd% for records that have crd. same way i want to store the string for i,l and h.in one string.

[Niladri_Biswas]

Try this Declare @t table (Record Varchar(20)) Insert Into @t Select 'OTH' Union All Select 'IA' Union All Select 'LE' Union All Select 'xxx' Select * From @t Where Record like '%[H,A,E]%' /* Result */ Record OTH IA LE Hope this helps Thanks in advance

Niladri Biswas

[Ganu Sharma]

You already have best solution.

[uspatel]

Finally I have achieve this by select *from Issue where ReqControlNo like '[ilh]%'