Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
davidc
Starting Member
26 Posts |
 Posted - 2011-07-14 : 11:04:18
|
| I am modifying a stored procedure which processes invoices in UK so I can use it for processing invoices which contain Hebrew characters'CAST(UDF.dbo.UDF_CleanChars(InvNbr,''ABCDEFGHIJKLMNOPQRSTUVWXYZ'',0) as NVARCHAR(25)) as InvCln_Txt,'+ @lcCR + 'CAST(UDF.dbo.UDF_CleanChars(InvNbr, ''???????????????????????????'',0) as NVARCHAR(25)) as InvCln_Txt_H,'+ @lcCR +The first three lines produce a letter only version of invoice number for English letters. When I substitute english letters with the hebrew alphabet, in the second three lines, the code is corrupted and the left arrow key moves the cursor to the right and vice versa. i cannot edit the code to correct it. What should I do. |
|
|
davidc
Starting Member
26 Posts |
Posted - 2011-07-14 : 11:25:43
|
| The ??? string is the hebrew alphabet in the new version. In the editor the text shown appears different. |
 |
|
|
davidc
Starting Member
26 Posts |
Posted - 2011-07-14 : 11:27:35
|
| 'CAST(UDF.dbo.UDF_CleanChars(InvNbr,''??????????????????????????'',0) as NVARCHAR(25)) as InvCln_Txt,'+ @lcCR + |
|
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2011-07-14 : 15:19:44
|
| >>the left arrow key moves the cursor to the right and vice versahuh?Are you using a SSMS query window to modify the stored procedure code?Is the second parameter on your UDF Nvarchar datatype?Be One with the OptimizerTG |
|
|
|
|
|
|
hebrew characters in sql code