adding zero before the value

[nitara]

I have to update the values of a table where if the year is 1-9 then add zero before the number and if its >= 10 then don't add zero .
so what query be written for this in pervasive

select ( dateC + (select case when len(datey) = 1 then

'0' else '' end + datey as datey1 ) + '/' + dateM + '/' + dateD ) from Tablename



I tried to do this way but its showing an error

Thanks in advance

 

[mirtheil]

What version of Pervasive are you using?
What error are you getting?
How is 'datey' defined in the database?


Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com