Re: How to define not equal (<>) in SQL statement

[Reuben Firmin]

Use the CDATA construct, e.g.:

       <![CDATA[
           SELECT * FROM Deployment
           WHERE environmentId = #environmentId#
           AND deploymentTime <= #end#
           AND deploymentTime >= #start#
           ORDER BY deploymentTime DESC
       ]]>

Ashish Kulkarni wrote:

Hi
I have a SQL statement as below, how do i define it in

xml

select * from mytable where mytest <> ' '

When i define it in xml file i get following error

The content beginning "<>" is not legal markup.
Perhaps the ">" (&#3e;) character should be a letter.


Ashish

__________________________________________________
Do You Yahoo!?

Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com