0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT 
  Id as [Comment Id],
  LEFT(
    SUBSTRING(Text, CHARINDEX('@', Text)+1, LEN(Text)),
    PATINDEX(
      '%[^a-z]%',
      SUBSTRING(Text, CHARINDEX('@', Text)+1, LEN(Text))
    )-1
  ) as oldName,
  Text
FROM Comments
Where Id = 246568

fork query

edited jul 13 14

created jul 13 14 jon.doe10500