Skip to Content
0
Former Member
Oct 05, 2005 at 05:04 AM

Comparison b/w two char field

47 Views

hi all

Here in following select query field gdatu is char field it storing date as in char format and i hv to compare it with date.Which is not possible in dis way.

can anyone suggest me any solution for dis problem.

here lv_pool_val_dt is date type field.

SELECT fcurr ukurs

INTO TABLE lt_tcurr

FROM tcurr

WHERE gdatu GE lv_pool_val_dt.

regards

sunanda