Hiya Ed ----
>>SELECT IIF(condition=.T.,PADL(ALLT(field),2),"ZZ") AS newfield.
>
>SELECT IIF(INLIST(cUserSecurityLevel,"A","B","C"),cUserSecurityLevel+SPACE(1),"ZZ")
But doesn't this assume that you know the length of the TRIMmed value of cUserSecurityLevel?
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05