RE: [Axapta-Knowledge-Village] Any Idea abou this?

Hi Subbu

You used a normal Axapta select or SQL statement?

If you used axapta declare the variable type as .... and resolve the problem

If you used SQL statement when you create a select command add the command Ltrim

Example:

SELECT     ACCOUNTNUM, VOUCHER
FROM         dbo.LEDGERTRANS
WHERE     (LTRIM(VOUCHER) = 'VA0001')

Best regards,

Diego M. Gagliano

Please fill free to contact me if you have any question.

I look forward to hear about you.

Start your day with Yahoo! - make it your home page

Sharing the knowledge on Axapta.

SPONSORED LINKS

`Axapta`	`Business finance course`	`Business finance online course`
`Business finance class`	`Business finance schools`	`Business finances`

YAHOO! GROUPS LINKS

Reply via email to