SQL dates and numeric columns

[Dave <dfx1@xxxxxxxxxxxxxx>]

Hi,



Trying to do date operations on a physical file where the date is coded in
3 different numeric fields Y, M and D



1 -  I created a view, can I do better than this :

date(trim(char(Y))!!'-'!!trim(char(M))!!'-'!!trim(char(D))) "MyDate"

 ?


2 – This works in an SQL session but the RPG compiler doesn’t seem to like
the ‘ !’ character. Any ideas ?



Thanks