I'm currently trying to setup a SQL View that's going to be used to pull info from a table and output it onto a label... Long story short the only piece I need help with is having the SQL view remove leading zeros from one column called "Reference". The current data in reference currently looks like "000048212". Of course this needs to happen without affecting the actual table. Also its always 4 leading zeros.
Thanks for any help,