Hi I have a filed which includes serial no of computers in order to make my reprot i need to get the serial number without the first charater for exp. SENNO. SCHC900 should be CHC900 or SZ100 should be Z100
thanks for your help
Use Left() and Len() functions to get it:
Right([Serial Number], Len([Serial Number]) -1) AS SerialWithoutFirstChar
Hope that helps.
If you want to change the serialNo in script:
mid(SerialNo,2,len(SerialNo)-1) as SerialNo
In a chart expression:
Hi miguel thaks for your fast response it works great thanks gidon
It would be sufficient to use the mid function with two parameters, like below:
mid([Serial Number], 2) as [Serial Number]
Framsteg Business Intelligence Corp.
I agree: easier, cleaner and simpler.
Retrieving data ...