SQL help needed

I'm stumped by something a programmer brought up to me a little bit ago. (5pm on Friday, just what I needed!)

I have an SQL statement that is coded as:

DATEG>=(left(cast(current_date as varchar(10)),4)

That statement works fine when I run the SQL statement using the iNav run SQL function.

When I try to run the same statement using RUNSQLSTM I get the following which fails:

DATEG>=(left(Cast(Translate(Concat(Substring(Cast(CURRENT_DATE AS VarChar(10) CCSID37),1,4)

For some reason RUNSQLSTM thinks it needs to translate CURRENT_DATE to CCSID 37 and inserts the appropriate code.

I am very far from being an SQL expert so can someone point me in the right direction?

Respectfully,
Kendall Kinnear
System Analyst
Standard Motor Products, Inc.
Work: 972-316-8169
Mobile: 940-293-7541

________________________________
Please consider the environment before printing this email.

The content of this e-mail (including any attached files) is confidential and may be privileged and protected by law. It is intended solely for the purpose of the person to whom it is addressed. If you are not the intended recipient of this message, please notify the sender immediately and delete the message (inclusive of any attached files). In addition, if you are not the intended recipient of this message, any disclosure, copying, distribution or taking any action in reliance of the contents of this email is strictly prohibited.