Added zeros to field

[dimak123]

Hi to all

Need help, somehow i am getting field on layout different from original data.

How can i show the exact field?

[dimak123]

it worked!!!
thanks!!!

[oknotsen]

Num'

Try it without that single quote, because it actually is a recognized built-in function name.

I use it almost every day.

[Gysbert_Wassenaar]

Yes, as you've noticed telling SQL Server to execute Qlikview functions doesn't work. You can use a preceding load like shown above in Jonathan‌‌'s post.

[tamilarasu]

You should put the code above your sql statement. I.e Preceding load. Anyhow, you got the solution.

[Gysbert_Wassenaar]

In T-SQL? Don't you mean the Format function perhaps?

[oknotsen]

No, in the preceding load.

Paste the code above the sql statement.

Load *,

Num(Field) as New;

[Gysbert_Wassenaar]

Never mind. I thought you were responding to his sql-server error message. See you on monday