>Dear Experts
>
>Please correct this command line
>
>a=alltrim(substr(str(YEAR(date())),1,4))
>
>I want to extract last two characters of year i.e. 05
>
>Please help
? RIGHT(STR(YEAR(DATE()),4),2)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.