SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
declare @text nvarchar(max) = 'abcd (123456)' declare @text_last_occurance_bracket int = 0 set @text_last_occurance_bracket = charindex('(',reverse(@text)) select @text ,len(@text) length ,reverse(@text) reversed ,@text_last_occurance_bracket text_last_occurance_bracket ,reverse(substring(reverse(@text), 2, @text_last_occurance_bracket - 2)) result_1 ,replace(right(@text, @text_last_occurance_bracket), '(', '') ,ltrim(rtrim(left(@text, len(@text) - @text_last_occurance_bracket))) result_2
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear