var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: TSQL for regular expression
Does anyone know a quick way to check in a funtion how to check if a variable contains any characters and also to check for the presence of numbers within the variable?
The char checking code won't work for some collations (e.g. Binary).
CASE WHEN @v LIKE '%[A-Za-z]%' THEN 'Got Chars' END
, CASE CASE WHEN @v LIKE '%[0-9]%' THEN 'Got Numbies' END
ur codings are working excelent.
"The data in a record depends on the Key to the record, the Whole Key, and
nothing but the Key, so help me Codd."
Good call rdjabarov!
Regex support is the primary reason most of my projects have opted for CLR support. For heavy-hitting string crunching and manipulation options, you really can't beat .NET RegEx.