Reputation
400
Top tag
Next privilege 500 Rep.
Access review queues
Badges
3 5 12
Newest
 Curious
Impact
~105k people reached

  • 0 posts edited
  • 0 helpful flags
  • 11 votes cast
19h
accepted Concatenation, with separators, where any combo of input fields might be null
20h
asked Concatenation, with separators, where any combo of input fields might be null
20h
accepted Trim Trailing Whitespace, Tab, Newline, Carriage Returns, etc
20h
comment Trim Trailing Whitespace, Tab, Newline, Carriage Returns, etc
Thanks this is great and nicely achieves the purpose.
2d
comment Trim Trailing Whitespace, Tab, Newline, Carriage Returns, etc
Thanks Tom. How can that function be changed to work for the right trim scenario, other than changing the LEFT to RIGHT in the IF statement? I don't fully grasp the use of STUFF and PATINDEX here.
May
2
asked Trim Trailing Whitespace, Tab, Newline, Carriage Returns, etc
Apr
28
accepted Search for X at the beginning of a line within a multi-line string
Apr
28
comment Search for X at the beginning of a line within a multi-line string
Thanks, that more or less did the trick, just needed to change CHAR(13) to CHAR(10)... R_MESSAGE LIKE '%' + CHAR(10) + '[A-Za-z].%'
Apr
28
asked Search for X at the beginning of a line within a multi-line string
Nov
17
asked Determine Which Parameters Passed Into Stored Procedure
Sep
29
awarded  Curious
Sep
29
awarded  Famous Question
Sep
29
awarded  Notable Question
Sep
29
awarded  Commentator
Sep
29
awarded  Editor
Sep
29
awarded  Popular Question
Sep
29
awarded  Scholar
Sep
29
awarded  Yearling
Oct
1
awarded  Famous Question
Sep
26
asked Optimizing UDF - Is Using DUAL Expensive