Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Krb_iiaba
Starting Member
16 Posts |
 Posted - 2004-01-20 : 14:02:08
|
| I have a url field in a database that contains any format for a url (ie http://www.sqlteam.com, www.sqlteam.com, sqlteam.com, http://sqlteam.com etc). I have a stored procedure that queries this data and returns output to many different apps... the idea is to format the url before it is returned so as to avoid programatically performing a bunch of string functions in all of those apps...what would be the easiest way of going about this... eaxmple of query below.SELECT nationalMembershipNumber,( o + '<BR>' + '<a href="' + url + '" target="_blank">' + url + '</a>') as o, etc etcThanks in advance! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
conditional formatting in stored procedure