Skip to Content
0
Jan 17, 2012 at 11:20 AM

Fields date and string(4)

30 Views

Hello

How can I filter a field type datum with the current year in the own select.

i.e

SELECT * INTO TABLE i_1

FROM fmfctrt

WHERE spras = 'S'

AND fikrs = p_fikrs

AND year(datab) <= '2012 (datab is a type dat)

and the length of one string field

i.e

SELECT * INTO TABLE i_1

FROM fmfctrt

WHERE spras = 'S'

AND fikrs = p_fikrs

AND length (fikrs) >= 4 (fikrs is a type char(4)).

Thanks in advance