SUBSTR - SUBSTRING function extension

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Nagabhushanam P » SUBSTR - SUBSTRING function extension

SUBSTR - SUBSTRING function extension

Rate Topic

Display Mode

Topic Options

Author

Message

Bhushan

Posted Saturday, October 13, 2007 3:46 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, November 21, 2012 10:51 AM
Points: 131, Visits: 90

Comments posted to this topic are about the item SUBSTR - SUBSTRING function extension

Post #410408

Jeff Moden

Posted Saturday, October 13, 2007 4:04 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 7:36 PM
Points: 32,931, Visits: 26,820

SQL Server has a LEFT and a RIGHT... no need to build a special function to do it as bad as Oracle ;)

--Jeff Moden

"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #410418

« Prev Topic | Next Topic »

Permissions