TRIM function and the || concatenation operators

TRIM function and the || concatenation operators

This is a discussion on TRIM function and the || concatenation operators within the SQL Server forums, part of the Microsoft SQL Server category; --> Hi, How would I translate these TRIM function and the || concatenation operators into SQL SERVER. Please help. select ...

		Unix Technical Forum > Database Server Software > Microsoft SQL Server > SQL Server
TRIM function and the \|\| concatenation operators

#1 (permalink)

08-01-2008, 10:39 PM

nguyenl

Junior Member

Join Date: Jun 2008

Posts: 3

TRIM function and the || concatenation operators

Hi,

How would I translate these TRIM function and the || concatenation operators into SQL SERVER. Please help.

select prop_type,
TRIM(section) || '-' || TRIM(township) || '-' ||TRIM(range),
nbhd, region,
inspct_cycle,
water,
sewer_septic,
unimproved_acres,improved_acres,
total_sqft from parcel,
legal_description

where legal_description.property_id = [PROPERTYID]
and parcel.property_id = [PROPERTYID] and parcel_year = 2008

Thanks,

-Long

« Calling Commonly Used SQL (reusable code) | FOreach operator »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Forum Jump

All times are GMT. The time now is 05:32 PM.