SQL Server String Functions. Session 12
Commonly used String Commands in SQL Server:
select charindex('@','su@nny@',4)
select charindex('@',emailid) from customer
select patindex('%b%',name) from customer
select patindex('@',emailid) from customer
select concat('sunny','pandita')
select concat(emailid,name) from customer
select left('sunny')
select left(emailid,3) from customer
select right('sunny')
select right(emailid,4) from customer
select upper('dsfsadfasdfasdfasdfasdf')
select upper(name) from customer
slect lower('dsfsdWWWRR')
select lower(name) from customer
select len('fsdfsdfsdf')
select len(name) from customer
select ltrim(' sdfsdfsd')
slect ltrim(name) from customer
select Rtrim('sdfsdfsd ')
slect Rtrim(name) from customer
select trim(' sdfsdfsd ')
slect trim(name) from customer
select replace('sunny','n','###'
select replace(emailid,'@','#') from customer
select replicate('sunny',2)
select replicate(name,2) from customer
select reverse(dept) from customer
select reverse('sunny')
select 'sunny'+space(10)+'pandita'
select space(name) from customer
select stuff(emailid,2,3,'pandita') from customer
select stuff('sunny',2,3,'pandita')
select substring(name,1,2) from customer
select substring('sunny',1,2)
On this page of the site you can watch the video online SQL Server String Functions. Session 12 with a duration of hours minute second in good quality, which was uploaded by the user Sunny@Pandita 04 March 2024, share the link with friends and acquaintances, this video has already been watched 461 times on youtube and it was liked by 25 viewers. Enjoy your viewing!
