I have a column of lenth 10 which could possible have leading zeroes.
How can I supress the leading zeros. I worked this out by checked byte by byte accross the 10 bytes, but us there is a masking function that I can use?
Thanks for the help
How to supress leading Zeros
Moderators: chulett, rschirm, roy
If you try math on a NULL value, you'll get an Abnormal Termination. Consider any of these options:
To enforce a set number of decimal places with rounding:
where x is the number of decimals remaining after the y decimal shift
Code: Select all
If ISNULL(link.column) OR NOT(NUM(link.column)) Then 0 Else link.column * 1
Code: Select all
If ISNULL(link.column) OR NOT(NUM(link.column)) Then 0 Else link.column + 0
Code: Select all
If ISNULL(link.column) OR NOT(NUM(link.column)) Then 0 Else OCONV(link.column, "MDxy")
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: