Hi @bimangunarathne
I can understand your confusion as you should not be using lowercase letters or symbols as they will produce the wrong answer (I will have this updated).
Take a look at the Tok operator instead – Tok interprets string data to another datatype | Reference | kdb+ and q documentation – kdb+ and q documentation (kx.com)
Many thanks,
Megan