Forum Discussion

alibaba82's avatar
alibaba82
Super Contributor
16 years ago

sql server jdbc query throws error when using 'lower' funct

Hello, I have using this query which works fine in sql server select top 2 lower(master_title) from rehab.master_title (nolock) using this in soapui 3.6 causes this error Tue Oct 26 03:21...
SmartBear_Suppo's avatar
SmartBear_Suppo
Icon for Alumni rankAlumni
16 years ago
Hi,

Could it be an option for you to change your SQL query to

select top 2 lower(master_title) as some_alias from rehab.master_title (nolock)

The thing is we are using org.w3c.dom.Document to parse SQL result as XML and parentheses seems to be a problem for XML (in column name).
Please let us know if it works as well.

Regards,
Dragica
/www.eviware.com