SQL Server 2008 TRIM character

We have table shipment:



Shipment_Name
-------------
FEDEX 2 Day 7/17/2012
DHL Intl. Freight 06/17/2012

We want only Shipment name and trim right date characters.

 

SELECT LEFT(Shipment_Name, LEN(Shipment_Name)-10) 
FROM SHIPMENT
Advertisements
By simplemsexchange Posted in SQL 2008

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