SQL Tricks | How to Remove Unwanted Characters from the Beginning of the String? #sqltips

In this SQL Tip, we try an amazing trick from LearnSQL.com 's SQL Cookbook to remove unwanted characters from the beginning of a string.

Check out the SQL Cookbook and other SQL Courses from LearnSQL.com here - Use Promo code: lsql-5z24dg for a 5% discount.

How to install SQL Server for practice?

Check out the complete list of SQL Query Interview Questions -

Must Do Data Analytics Certifications -

Google Data Analytics Professional Certificate

Google Advanced Data Analytics Professional Certificate

Best Data Science / Analytics / SQL courses
Learn SQL Basics for Data Science Specialization

Beginners to Python Programming

Data Science and Business Analytics with Python

IBM Data Science Professional Certificate

Data Science Fundamentals with Python and SQL Specialization

Python for Everybody Specialization

Google Data Analytics Professional Certificate

Coursera Plus - Data Science Career Skills

Please do not forget to like, subscribe and share.

For enrolling and enquiries, please contact us at

[ayushtiwari]

We can use replace as well by replacing that character with ''.

[jakubromanowski]

I've checked that platform and it's pritty cool!
Thanks!

[shashidharr]

error Msg 102, Level 15, State 1, Line 419
Incorrect syntax near 'Lx0'.

[sayandeepmajumder]

and how to remove different characters from multiple such strings?