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 |
|
sqldev80
Yak Posting Veteran
68 Posts |
 Posted - 2006-05-24 : 15:01:39
|
| Is there a function where I can replace invalid characters in my XML I do this in my proc to create XMLselect @feed = '<g:label>'+''+ replace(@desc_english, '&', '&')+''+ '</g:label>'some times desc_english will have invalid XML charactersso is there a function to replace them |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-05-25 : 14:56:46
|
| There are lots of things that need replacing ... can you not use FOR XML to generate the actual XML and let that take care of the problem for you?Kristen |
 |
|
|
sqldev80
Yak Posting Veteran
68 Posts |
Posted - 2006-05-25 : 15:25:30
|
| I had to use lot of replace to do thatmy data had lot of invalid XML and i could not use for XML coz for XML would not convert it into the format i wantedi hope SQL had an inbuild function to escape invalid XMLi gues we could create one otherwise |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-05-26 : 12:50:39
|
| "for XML would not convert it into the format i wanted"Can you explain what "format" problem you had pls?Kristen |
|
|
|
|
|
|
Is there Function to Escape invalid XML characters