Odd behaviour with .Select

[pachjo]

HI,

I have a field in my table as nvarchar(50) and have also tried varchar(50)

If I set n below to a numerical value only the .select line below works and successfully finds the record with the tranid

However as soon as I try to append "NQT1" onto the beginning of n the select line errors with cannot find column (the value in n)

 n = String.Format("{0}{1}", "NQT1", n)

 s = String.Format("tranID = {0}", n)

 Dim dr() = Me.PdslbDataSet1.Transactions.Select(s)

So if n = 12345 the select works fine

but if n = NQT112345 the select says it can't find column NQT112345

Che?

Any pointers please?

Thanks

 

[pachjo]

Sorted!

s = String.Format("{0}'{1}{2}'", "tranID = ", "A1-", n)