Of course! I was trying to think of an in-line solution, but that will work great. Thanks!
>SET CENTURY ON?
>
>>The Patient.ptDOB below is a 2-digit date. What is the simplest way to convert it to a 4-digit year date in a SQL statement? Thanks!
>>
>>
>>PADR(THIS.Strip(TRANSFORM(Patient.PtDOB, '@T')), 30, ' ') AS PID_07_00_DateOfBirth, ;
>>