View original (French)

Remove 0 non-significant from an SQL result

Solved
xav3601 Posted messages 3390 Status Membre -  
xav3601 Posted messages 3390 Status Membre -
Hello,

I would like to know how to remove the insignificant 0s from one of my fields in the result of a SQL query.

Example:

My field lbtest contains 000101;

I do a 

 select lbtest from my table


I logically get: 000101.

So what is the query to get: 101.

Thank you in advance for your help!
Culture is like jam, the less you have the more you spread it!

1 réponse

Réponse 1 / 1
xav3601 Posted messages 3390 Status Membre 312
 
Well, there you go, I'm answering myself :-)

Actually, it's quite simple, you just have to tell it that we want them in quantity! 

 Select to_number(lbtest) from matable


There you go
--
Culture is like jam, the less you have, the more you spread it!
3