Mega Code Archive

 

Categories / MSSQL / Select Query

 

Wildcard characters recognized by SQL Server for use in regular expressions

Wildcard    Searches for %           Any string of zero or more characters. _           Any single character. [ ]         Any single character within the specified range (for example, [a-f]) or the specified set (for example, [abcdef]). [^]         Any single character not within the specified range (for example, [^a-f]) or the specified set (for example, [^abcdef]).