SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
declare @text nvarchar(max) = 'abcd (MSC) (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(replace(right(@text, @text_last_occurance_bracket), '(', ''), ')', '') result_1 ,ltrim(rtrim(left(@text, len(@text) - @text_last_occurance_bracket))) result_2
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear