Hi, the N' is because strings are UNICODE in Microsoft Dynamics 4.0. N' is the SQL notation for UNICODE strings. It is not a bug. It is by design. Regards EG Utility A/S Michael Troelsen
_____ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of gopala krishna Sent: 2. oktober 2007 10:13 To: axapta knowledge; axapta development Subject: [Axapta-Knowledge-Village] SQLLiteral is giving wrong result Hi, When I run this piece of code I am getting different results in 3.0 and in 4.0. SqlSystem sqlSystem = new SqlSystem(); ; print sqlSystem.sqlLitera-l('000213_-003'); Pause; In 3.0 it is printing as '000213_003' and in 4.0 it is printing as N'000213_003' Extra N is prefixing in 4.0 which is resulting to inconsistency. This is happening when I try to post the journal using the LedgerJournalCheckP-ost class. I am connecting to SQL server 2005 for both AX3.0 and AX4.0. Similar code we can see in Table/LedgerJournal-Table/Methods/ numOfVouchers(-) . Did anybody encounter similar problem? Is it a bug in AX? Thanks. Gopal Get the freedom to save as many mails as you wish. To know how, go to HYPERLINK "http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools-08.html"http:// help.-yahoo.com/-l/in/yahoo/-mail/yahoomail/-tools/tools--08.html [Non-text portions of this message have been removed] No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.488 / Virus Database: 269.13.37/1042 - Release Date: 01-10-2007 18:59 No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.488 / Virus Database: 269.14.0/1048 - Release Date: 03-10-2007 20:22 [Non-text portions of this message have been removed]