topic Re: Select statement operators in ecc 6. in Application Development and Automation Discussions

Select statement operators in ecc 6.

Former Member — Fri, 21 Aug 2009 09:38:41 GMT

Hi Experts,

I have a small doubt about the '>=' ( greater than or equal to ) operator usage in select statement. Is this operator by any chance perform not as desired in ECC 6.0. Is it a good option to use 'GE' instead of '>='. ?

It may sound a bit awkward, but still I would like to know. I am facing a situation, which could be related to this. An early response would be highly appreciated.

I would request,you NOT TO REPLY with links/explanations which says how to use select statement. Only answer if you have the answers related to this query.

Regards,

Sandipan

Re: Select statement operators in ecc 6.

jaideepsharma — Fri, 21 Aug 2009 09:52:30 GMT

Hi,

The only difference is GE will take a little more time than >= as system need to convert the keyword into actual operator when fetching data from Database.

KR Jaideep,

Re: Select statement operators in ecc 6.

rainer_hbenthal — Fri, 21 Aug 2009 09:57:30 GMT


> Hi,
> The only difference is GE will take a little more time than >= as system need to convert the keyword into actual operator when fetching data from Database.
> 
> KR Jaideep,

????? Every Open SQL statements is translated to the SQL slang the underlying database is talking regardless if you type GE or >=

If the result differs using >= or GE i would open a call at SAP instead of asking in SDN.

Re: Select statement operators in ecc 6.

Former Member — Fri, 21 Aug 2009 10:04:33 GMT

Both are same.Use any ..

Re: Select statement operators in ecc 6.

Former Member — Fri, 21 Aug 2009 10:11:01 GMT

It is recommended that you only use the operators =, <>, <, >, <=, >= or only the operators EQ, NE, LT, GT, LE, GE.

Obsolete forms: ><, =<, =>

so >= is same as GE.. you can use any thing. no issues.

Re: Select statement operators in ecc 6.

Former Member — Fri, 21 Aug 2009 10:29:25 GMT

Hi,

Thank you for your replies. As fas as I could understand that there is no as such limitations in ECC 6.0 in using both of them.

Regards,

Sandipan

Re: Select statement operators in ecc 6.

Former Member — Fri, 21 Aug 2009 10:40:58 GMT

yes