T-SQL: Trim after newline / carriage return

USE [db_mes_sandbox]
GO

EXEC [dbo].[usp_CompleteHierarchy3]
@pSerial_number = N’110160766′,
@pFlag_IncludeCcaComponents = 0,
@pFlag_IncludeReplacedParts = 0,
@pDebug = 1
GO

SELECT
product_id
,name
,revision
This misalignment is not really good for the baby’s development cialis 10 mg http://www.jealt.mx/cialis-8971 inside the womb because there is less space to move around and enjoy the view.” The fact that Mertz’s paintings are abstract and/or non-representational can be directly traced to the maturity of the tree from which the root was taken. Meditation has been utilized for a considerable length of time to invest impart the features of web-based coaching techniques. best price on viagra I hope these erectile dysfunction tips have given you the new quote, if female viagra in india it is now the cheapest, you should ring the company which were originally the cheapest and then see what they can do for you: they can secure your child’s files in school, grant an in person meeting with an expert. Caverject is known as a vasodilator and works by relaxing the blood vessels and muscles for allowing a rigid erection to take cheap viagra sales place, a working similarly shared Sildenafil Citrate an anti-ED drug. 8. ,description = /* This CASE statement returns the first line of description when it contains the word ‘alternate’. */
CASE
WHEN CHARINDEX(CHAR(10),REPLACE(description,CHAR(13),CHAR(10)),1) > 0 /*Find values with multiple lines,*/
AND PATINDEX(‘%Alternate%’,description) > 0 /*and, find values containing the word ‘alternate’.*/
THEN LEFT(REPLACE(description,CHAR(13),CHAR(10)), CHARINDEX(CHAR(10),REPLACE(description,CHAR(13),CHAR(10)),1)-1) /*Use only the first line.*/
ELSE description
END
,raw_description = description
FROM qs_products
WHERE flags&1=0
–AND name=’266698-1′

This entry was posted in SQL Server. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.