String Manipulation in SQL Server

Question

Is there any way of setting an "Column Alias" in SQL Server?

For Example i have two columns. Description and Price

ID    colDescription                                colPrice
1     Red ball costs %colPrice% dollars             2
2     Blue ball costs %colPrice% dollars            3

The selection of colDescription for ID=2, should fetch

Blue ball costs 3 dollars

Oups! I now got the point! But string substitution is the only way? Another way of referencing the value does not exist? (I am sorry about my English). — OrElse
– OrElse, Commented Dec 8, 2009 at 21:45
Depends on what do you exactly want to do with the data. You could have a trigger that updates the other column, you could have a computed column. — Vinko Vrsalovic
– Vinko Vrsalovic, Commented Dec 8, 2009 at 21:47

Vinko Vrsalovic · Accepted Answer · 2009-12-08 21:38:15Z

2

The manual way to do so would be:

select replace(coldescription,'%colPrice%',colprice) from table

answered Dec 8, 2009 at 21:38

Vinko Vrsalovic

342k55 gold badges341 silver badges374 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Keith Adler · Accepted Answer · 2009-12-08 21:51:19Z

0

You could use a Computed Column since you're on SQL Server 2005:

http://msdn.microsoft.com/en-us/library/ms191250.aspx

edited Dec 8, 2009 at 21:51

answered Dec 8, 2009 at 21:44

Keith Adler

21.2k29 gold badges123 silver badges193 bronze badges

1 Comment

Keith Adler Over a year ago

It's an extremely fast and efficient mechanism, however I prefer to abstract out presentation and business logic from the data store myself.

Collectives™ on Stack Overflow

String Manipulation in SQL Server

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related