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

2005-12-09 Thread Jeff Butler
Sorry for the wierd format this is better:   select * from mytable where mytest ' '   Jeff Butler     On 12/9/05, Jeff Butler <[EMAIL PROTECTED]> wrote: Put it in a cdata section like this:   select * from mytable where mytest ' 'Jeff Butler  On 12/9/05, Ashish Kulkarni <[EMAIL PROTECTED] > wr

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

2005-12-09 Thread Reuben Firmin
Use the CDATA construct, e.g.: 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 ">" (e;) cha

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

2005-12-09 Thread Jeff Butler
Put it in a cdata section like this:   select * from mytable where mytest ' 'Jeff Butler  On 12/9/05, Ashish Kulkarni <[EMAIL PROTECTED]> wrote: HiI have a SQL statement as below, how do i define it inxmlselect * from mytable where mytest <> ' ' When i define it in xml file i get following errorT

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

2005-12-09 Thread Nathan Maves
What database are you using? Why not use != ? If you can then I would use < and > Nathan On Dec 9, 2005, at 11:01 AM, 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

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

2005-12-09 Thread Ashish Kulkarni
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 ">" (e;) character should be a letter. Ashish ___