Select statement operators in ecc 6.

[Former Member]

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

[jaideepsharma]

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,

[rainer_hbenthal]

>

> 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.

[Former Member]

Both are same.Use any ..

[Former Member]

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.

[Former Member]

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

[Former Member]

yes