• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 246
  • Last Modified:

sql and xml syntax issue

In Query Analyzer (MSsql) one enters "<" for less than, however, pasting the query into an xml file for another routine to read is syntactically incorrect. That is, "<" signals a tag to follow and the query bombs. I'm unsure if changing "<" in an xml file to "&lt;" is the workaround. Any suggestions? Thanks.
1 Solution
this sounds strange, but can you maybe write "LESS THAN" directly?
For xml < means starting a Tag. Just replace them with  "&lt;". It will fix the things. And when reading at the other side be sure this changed is handled also
cwest1Author Commented:
Just wait till we're writing and mixing C# and sql procs in SQL Server! That ought casue some problems :)
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.


Glad I helped.

Can you please explain why B grade? I think I answered you completely... if not - you can ask for clarifications.

See the grading policy here:

It's not for the points but for the PAQ value - if it is be then whoever sees the question will think it is not complete answer. But if you have your reasons, I'll be happy to hear them

cwest1Author Commented:
I'm sorry, I wasn't fully aware of the grading paradigm. An "A" is fine.
Done, thank you.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now