Try to pad ndc to the desired lenght.

Select DISTINCT PADR(STRTRAN(ndc,'-',''),11) as ndc ;
  From er3 Into Cursor ndctemp readwrite

>I have a SP that uses the xml_prepare function to create a table of an xml file passed to it. I have used this in the past but now when I try to use the same logic I get a table of NULL values. The VFP coding is as follows:
>
> Select DISTINCT STRTRAN(ndc,'-','') as ndc From er3 Into Cursor ndctemp readwrite -- this creates the needed cursor
>
> =contengine(sdate,edate,"ndcusage")
>
>in the function I have this code:
>
>ndcnum = ''
>Select ndctemp
>
>If Reccount('ndctemp')>0
> =Cursortoxml("ndctemp","ndcnum",2)
>Else
> x=Messagebox("No saletypes were detected to send to SQL server. Please verify.",16,"Data validation.")
> Return
>Endif
>
>
>sdate=Dtos(date1)
>edate=Dtos(date2)
>
>hconn=SQLConnect("pbisqlmemsales")
>
>lcsql="exec contract_engine ?ndcnum,?sdate,?edate"
>lnResult=SQLEXEC(hconn,lcsql,"&cndccursorname")
>
>In the sp I have this code:
>
>ALTER procedure contract_engine ( @ndcnum text,
> @sdate datetime,
> @edate datetime)
>as
>
>declare @iDoc int
>execute sp_xml_preparedocument @iDoc output, @ndcnum
>
>SELECT *
>INTO #ndcnums
>FROM OPENXML ( @idoc , 'VFPData/ndctemp')
>WITH ( ndcnum char(11) )
>
>select * from #ndcnums
>
>When I pass a cursor of eight numbers to this procedure (the whole procedure is much longer but it is messing up at this first part) I recieve a table with 8 records that have NULL for values. What am I missing here?!?
>
>Thanks in advance
>Kelly