CODEWITHSUNDEEP
sqlxmlmetamug
SurajRajesh
SurajRajesh

Reputation: 109

How to use less than < and greater than > symbols in metamug XML

How to use less than "<" and greater than ">" symbols in metamug XML in the resource file and SQL console

select * 
from tbl_reservation 
where fare > 100 
  and fare < 50000

Upvotes: 4

Views: 3296

Answers (2)

Kainix
Kainix

Reputation: 1216

Firstly < and > works in SQL console

With < > With

Without < > Without

But to use them in resource file you'll have to escape them as per the below table enter image description here
For more as per these guideline
So your query will be

select * from tbl_reservation where fare lt 100 and fare gt 50000

Upvotes: 5

M. Rezaeyan
M. Rezaeyan

Reputation: 408

you should use XML Escape Characters:

So, 

select * from tbl_reservation where fare gt 100 and fare lt 50000

Upvotes: 4

Related Questions