Common T-SQL string functions

T-SQL commonly used string functions none? SELECTSUBSTRING (123456,2, 3); -- 234 SELECTLEFT (123456,3); -- 123 SELECTRIGHT (123456,3); -- 456 SELECTLEN (Hello); -- 2 SELECTDATALENGTH (Hello ); -- 4 SELECTCHARINDEX (); -- 2 SELECTPATINDEX (% [0

T-SQL commonly used string functions none? Select substring ('20140901', 2, 3); -- '20160901' select left ('20160901', 3); -- '20160901' select right ('20160901', 3 ); -- '200' select len (' '); -- 2 select datalength (''); -- 4 select charindex ('23', '123 '); -- 2 select patindex ('% [0

Common T-SQL string functions <无>

? Select substring ('20140901', 2, 3); -- '20160901' select left ('20160901', 3); -- '20160901' select right ('20160901', 3 ); -- '200' select len (' '); -- 2 select datalength (''); -- 4 select charindex ('23', '123 '); -- 2 select patindex ('% [0-9] %', 'abc123gh'); -- 4 select replace ('1-1 ','-','. '); -- '1. 1 'select REPLICATE ('A', 4); -- 'aaa' select stuff ('abc', 2, 0, 'abc '); -- 'abcbc' select upper ('abcd'); -- 'abcd' select lower ('abcd'); -- 'abcd' select rtrim ('abcd '); -- 'abc' select ltrim ('abc'); -- 'abc'