How to concat numerical fields

[Guest.Visitor]

Convert them to character first. Something like digits(MM) concat '/' concat digits(dd) concat '/' concat digits(yy) As written, it'll look OK only if the fields are defined as having 2 digits. If they're 3 or longer, you may have to remove leading zeros with SUBSTRING.

[Guest.Visitor]

Ken: Thanks for your tip.

[Guest.Visitor]

We have an item file which has 3 numerical fields to hold year,month and day. I have to cat them in MM/DD/YY format in SQL and got a error "Argument * N of function CONCAT not valid". I found that CONCAT function wouldn't work on numerical field. Please help. Many thanks.