LSTR() and RSTR(): Enhanced LEFT() and RIGHT()

Quite often I need to cut off the first (or last) few characters of a string. To do just that I created two functions LSTR() and RSTR().Syntax: LSTR( @stringtocut, @length )Note: @stringtocut is trimmed in the functionWhen @length is equal or larger than zero, this function performs the same as LEFT( LTRIM(RTRIM(@stringtocut)), @length ).When @length […]

1.67 (3)

2007-09-13

849 reads

Blogs

Microsoft Tools That Help Query Tuning

By

Query tuning is not easy. In fact, for a lot of people, you shouldn’t...

Author of the Year 2019 Nomination at MSSQLTips

By

This year I’ve been nominated again for the Author of the Year award at...

Extended Events Misperceptions: Profiler is Easier

By

I know, I know, I’m on #teamexevents so I think that Extended Events can...

Read the latest Blogs

Forums

how to create query based on optional field on temp table ?

By ahmed_elbarbary.2010

problem how to create query based on optional field on temp table ? I...

how to create query based on optional field on temp table ?

By ahmed_elbarbary.2010

problem how to create query based on optional field on temp table ? I...

SQL Transaction Replication on a large DB

By ARPRINCE

I want to create a transaction replication (SVR-A to SVR-B) from scratch on one...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers