substr(intpartno,1,1)

[Raymond Chiu]

datarows = Me.DataSet2.Tables(0).Select(" custcode='" & Me.TextBox1.Text &
"' and substr(INTPARTNO, 1, 1) = '" & clayer & "'")

I find that substr(intpartno,1,1) does not work when I replace it with 'D'
matching with clayer' value ="D".

Why?

 

[Guest]

Hi, Raymond

The reason is substr is not a valid SQL function. Use SubString instead
See
http://msdn.microsoft.com/library/d...rfSystemDataDataColumnClassExpressionTopic.as

Bin Song, MC

----- Raymond Chiu wrote: ----

datarows = Me.DataSet2.Tables(0).Select(" custcode='" & Me.TextBox1.Text
"' and substr(INTPARTNO, 1, 1) = '" & clayer & "'"

I find that substr(intpartno,1,1) does not work when I replace it with 'D
matching with clayer' value ="D"

Why