To excludes '00' after BR_CODE

[nevilledhamsiri]

Hi Dear,

Please suggest couple of solutions where I may exclude 00 appear after BR_Code.

Thanks

Neville

[sunny_talwar · Accepted solution]

May be this

Left(BR_CODE, Len(BR_CODE)-2) as BR_CODE_NEW,

[nevilledhamsiri]

Thanks Sunny,

It works well.

Neville