Login | Register   
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL
Expertise: Advanced
Mar 1, 2005

Add SQL Text Fields

Text fields need special treatment in SQL. Here's how to add two text fields:

CREATE TABLE Foo (a int, b text)

--Table Foo has b as text data type.

INSERT INTO Foo VALUES (1,'qwe')
INSERT INTO Foo VALUES (1,'zxc')
INSERT INTO Foo VALUES (2,'123')
INSERT INTO Foo VALUES (2,'abc')



select 

coalesce(convert(varchar(8000),t1.b), '')+ coalesce(convert(varchar(8000),t2.b), '')
from foo t1 join foo t2
on t1.a=t2.a

and coalesce(convert(varchar(8000),t1.b), '')< coalesce(convert(varchar(8000),t2.b), '')
Parthasarathy Mandayam
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap