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 |
|
davidshq
Posting Yak Master
119 Posts |
 Posted - 2006-01-30 : 22:16:48
|
| I'm trying to take the text in a column, "http://www.nameofsite.com" and change it into a hyperlink by using the following statement:update Game set Source='<a href="' & source & '">BoyScoutTrail.Com.</a>' where Source LIKE '%http%'But I keep getting errors, any ideas?David.- http://www.gamesecretary.com/- http://www.thehungersite.com/- http://www.grid.org/ |
|
|
shallu1_gupta
Constraint Violating Yak Guru
394 Posts |
Posted - 2006-01-30 : 23:18:44
|
| try thisupdate Game set Source='<a href='" & source & "'>BoyScoutTrail.Com.</a>' where Source LIKE '%http%' |
 |
|
|
davidshq
Posting Yak Master
119 Posts |
Posted - 2006-02-04 : 20:42:11
|
| Thanks, ended up the error was with trying to combine varchar and text. I ended up solving this programmatically by using an If..Then statement in ASP.NET to find http and then replace it with the URL.David.- http://www.gamesecretary.com/- http://www.thehungersite.com/- http://www.grid.org/ |
|
|
|
|
|
|
Hypertext Link.