Viewing 2 posts - 266 through 2 (of 267 total)
UPPER(LEFT([State], 1)) + LOWER(SUBSTRING([State],2,LEN([State])))
Is one way of doing this, though it would be better to update your insert Stored Procs than use a trigger.
March 28, 2008 at 10:47 am
#795336