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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-11-16 : 15:23:49
|
Patrick writes "Esteemed gurus of SQL,
How do I replace a character like '&' with its equivalent
character code '%26' in the output of a query.
I am outputting values directly from SQL to Flash Generator which reads the '&' character as a variable identifier.
Much like PHP uses the '$' character.
So the value 'Fitch & Mather' goes all the hell unless its output as Fitch %20 Mather'.
While your at it... tell me who we should appoint as benevolent dictator since it looks like we will be without a working democracy for a while...
~ Patrick" |
|
|
|
|
|
instring replace in query output. Ex. output & with %26