or 2 of the SQL Ike how to sort data by like?

Name like "%a%" OR Time "%b%"

How to finish the result of like a in row B?

Reply to discussion (solution)

... order by if (InStr (Name, ' A ') >0,1,0) desc

... order by if (InStr (Name, ' A ') >0,1,0) desc
Does Big Brother have an example of the whole sentence? I can not understand this half sentence!

This half is enough to understand.
That is, by looking for a string containing ' a ' to turn 0, 1, and then sort by 01, containing 1, not containing 0
The final sort is Order by if (InStr (Name, ' A ') >0,1,0) desc

This half is enough to understand.
That is, by looking for a string containing ' a ' to turn 0, 1, and then sort by 01, containing 1, not containing 0
The final sort is Order by if (InStr (Name, ' A ') >0,1,0) desc

Actually I want to arrange the result is probably the following statement, the 2 parentheses in the data order, first in the first parenthesis, in the 2nd parenthesis ....

SELECT * FROM CS where (Time like ""%a% or name "%b%" or Time "%e%") or (Time Like "" "%11% or name"%22% "or Time like "%33%")

The same, with the above statement the same, combined Ah, this does not understand?
Order BY if (InStr (Name, ' A ') >0,1, (if (InStr (name, ' B ') >0,1, (if (InStr (name, ' E ') >0,1,0)) desc

