How do we get the distinct characters in any column of a database?

[vkolasani]

Hi,

I am looking for unique distribution of characters in any column of a data base.

I am using below expression but it is giving the chrecters in every and is the reason I am getting duplicate charecters.

Advance thanks and any help on this would be appriciated.

Thanks,

Venu

[krishna_2644]

Expression in the picture are just some random symbols.can you paste the expression?

[vkolasani]

,if(max(len(purgechar(lower([$(vFieldName)]), '0123456789abcdefghijklmnopqrstuvwxyz.""-_()/\''',))) > 0, CONCAT(DISTINCT TRIM(purgechar(lower(([$(vFieldName)])), '0123456789abcdefghijklmnopqrstuvwxyz.""-_()/\'','))),'') as [_Non AlphaNumeric11]