How to retrieve data but by shortening up its length

SELECT

 

dataCol1, case when len(dataCol1) charindex(@urKeyWord , dataCol1 ) > 50 then substring(dataCol1,charindex(@urKeyWord , dataCol1 ),charindex(@urKeyWord , dataCol1 ) + 50 ) else substring(dataCol1,charindex(@urKeyWord , dataCol1 ),len(@urKeyWord) ) end

FROM

 

myTable

WHERE

 

dataCol2 NOT IN (SELECT col FROM anotherTable)

Advertisements

About Saad Khan

Saad is an ASP.NET developer with 4 years of experience, and has also made a number of contributions to the Sitefinity marketplace and community. He loves to explore new code, and create innovative tools and procedures while exploring new approaches in his work with Sitefinity and MVC. As an experienced .NET developer, he frequents both Telerik and Microsoft technologies. In his spare time, Saad is an avid gamer and movie fanatic, and also experiments with new and interesting tools on the Microsoft platform.​​

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: