DTS ActiveX VBScript varchar problem
Posted on 2004-11-03
I've got an activex script that emails orders out to suppliers. They need to receive the data in a particular format - and need some field lengths to be a particular size... the problem i'm having is if i use this code....
elseif x.name = "title" then
strLine= strLine & chr(34) & left(x.value,4) & chr(34) & chr(44)
and the title field is nchar then i get a field entry of "MR ", (which is right) but if the title field is varchar i get "MR", (which is wrong)
Does anyone know how why this happens or if I can get around it without changing all my database fields?