Calculated column

[RamLal]

there is a column called "customer", It has four letter data in it for ex: "ABCD". I am trying to create a Calculated column , which will have all the data starts with "A" from customer column and only display last two letters ( in this case : "cd") in that column.
your response is highly appreciable.

Thanks.

[blom0344]

Code Select Expand


CASE WHEN
[Customer] like 'A%'
then (substring([Customer,3,2))
else (null)


As definition of the calculated data-item..