Leading zeros

[#1]

Hi guys.

I need help on an issue. I have a view in sql server that brings two records 014801 and 14801.

These are two different items.When i  make a select from that view on a qvw the result is that it brings only one of the records.

I have tried convert(varchar,item) but it didnt work. Can anyone help?

[#2]

The thing is that I have hundreds of this case, 014802 and 14802,014803 and 14803 and so on...

[sivarajs · Accepted solution]

This might be you are looking for

[#4]

Thank you!

I added a load statement before the select and it worked!

Thank you all guys!