Could anyone tell me the best way to change an output of P0123 to 123? i.e. drop the letter 'P' and also any leading zeros. We have a report that outputs terminal ID's which range from P0001 through to P0536.
I can drop the 'P' easily enough, but being a complete noob with SQL, can't figure out how I can drop the P000 from terminal ID P0001 for example.