sql like - Is it possible in sql to group by fields matching some pattern? -


Is it possible to group with LIKE pattern in SQL? I would like to achieve something like this:

ID | Name 1 Mike 2 | Bob 3 | Bill 4 | Alice

and then like the query: _pattern_ Select the user group by name, for example i want to match pattern 'b *', '* l *' and 'Mike' gives output:

 B * | Bob | Bill * L * | Bill | Alice Mike | Choose 'B *' as the Mike, select the name WHERE name 'B' 'Union All' from the table, '* L *' as the mask, name ''% l% '' from the table Unius all 'Mike 'Choose' Mike 'name from table,' Mike 'as table name, select Mask'  

Comments

Popular posts from this blog

c# - sqlDecimal to decimal clr stored procedure Unable to cast object of type 'System.Data.SqlTypes.SqlDecimal' to type 'System.IConvertible' -

Calling GetGUIThreadInfo from Outlook VBA -

Obfuscating Python code? -