Replicate, Space, Patindex, Replace and Stuff string functions in sql server 2008 Part 24

38
3



In this video we will learn about commonly string functions in sql server 2008 like Replicate, Space, Patindex, Replace, and Stuff. We will look at some real time examples of where we can use these functions.

Text version of the video

Healthy diet is very important both for the body and mind. If you like Aarvi Kitchen recipes, please support by sharing, subscribing and liking our YouTube channel. Hope you can help.

Slides

All SQL Server Text Articles

All SQL Server Slides

All Dot Net and SQL Server Tutorials in English

All Dot Net and SQL Server Tutorials in Arabic

string functions, sql server 2008, sql server 2005, sql mask characters, sql mask sensitive data, sql mask phone number, sql find pattern in string, sql repeat string n times, sql server repeat spaces, sql string replace example

Xem Thêm Bài Viết Về Mobile Khác: https://sealsystem.org/mobile

Nguồn: https://sealsystem.org/

38 COMMENTS

  1. How Do i Mask Data Which Is Already Present And For Feature insertion How it is possible to next storing data inserted with mask as per given mask definition can you share a knowledge on this please

  2. Come on Venkat, or someone…if could explain what is happening here… Because without CHARINDEX('@', Email)+1) at the end also return the same result :
    select FirstName, LastName,

    SUBSTRING(Email, 1, 2) + REPLICATE('*',5) + SUBSTRING(Email, CHARINDEX('@', Email), LEN(Email))

    from tblEmployee

  3. Hello Sir! I really appreciate your hard work simplifying SQL in the best way ever, I admit I never found anyone who can do it in the best way as you do. Thus, I really want to be like you, you're my role model, I am doing my best for the moment, however, I just want to know how much it took you to learn using SQL just as you do now ? A year, two … ? I am actually making sure to learn all of what you provided in here and I am learning fast, does this mean if I ever finished all of your tutorial videos, and eventually will be able to use all of the queries you provided that I am well qualified to use SQL ? I hope you would answer me so soon.
    regards.

  4. How can i split this into two columns
    like
    ID and Description
    867 Other infectious and parasitic diseases diagnoses with mcc
    Integer value in Id column and rest will be in Description column]

  5. Thanks Venkat for providing such comprehensive tutorial. I have been practicing sql questions online and came across a question to find median of a column. I would love you to do a tutorial on writing a sql for finding the median of a column in a table (for example median salary per department).

  6. I don't understand the idea of SPACE-function. I understand how it works, but I don't understand why it exists. SPACE(5) = REPLICATE(' ', 5), right? Why separate function is needed?

  7. It's the best video tutorial, even if it is to compare with the courses wich I bought. I'm reading also the book Querying Microsoft SQL Server 2012 Training Kit and I can see the quality of your video's. Thank's for your work.

  8. Hi Venkat ,your videcs are awesome and easily understandable,thanks a lot for making it,i got doubt regarding patindex and charindex ……when I am using charindex it is giving me result as you said …I was trying it with patindex too…..where I got the result forselect SUBSTRING(Email,PATINDEX('%@%',Email)+1,LEN(Email)-PATINDEX('%@%',Email))as domain from tblemployee   but when I use in group by it is throwing errorselect SUBSTRING(Email,PATINDEX('%@%',Email)+1,LEN(Email)-PATINDEX('%@%',Email))as domain, count(Email) from tblemployee group by SUBSTRING(Email,PATINDEX('%@%',Email)+1,len(Email)-PATINDEX('@',Email))can u suggest me y?thanks in advance…..

  9. select ID, Name, SUBSTRING(Email,1,2)+REPLICATE('*',2)+SUBSTRING(Email, CHARINDEX('@',Email),LEN(Email)) from tblPerson
    I think len(email) is better because anyways there are no characters after the last .domain name. It saves the trouble of calculating the remaining length but still for other situations we might need the exact remaining length. Nice explaination. Just watching one by one.

  10. Mask all characters between the first letter and the @ sign:
    select *, stuff(Email, 2, len(Email) – (len(Email) – charindex('@', Email) + 2),
    replicate('*', len(Email) – (len(Email) – charindex('@', Email) + 2))) as StuffedEmail from tblEmployee

  11. Hi, Awsome. we are learing lot of things from right professional
    .
    I have one small doubt on Patindex . i understood that it is used with wild card.

    But,     select * from emailtable where email like '%@aaa.com'

    retrieves the same result.

        select email,PATINDEX('%aaa.com',email) as occurance
        from emailtable where PATINDEX('%aaa.com',email)>0

    these returns same. what is the use of pat index in this situation ?

LEAVE A REPLY

Please enter your comment!
Please enter your name here