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