converting sql from VB 6 to .Net 1

[ribbons]

I'm trying to convert some SQL from VB 6.0 to .Net. Can anyone tell me why the following is not correct???

sWhere = str.Substring(sWhere, str.Length(sWhere) - 4)

I'm converting FROM:

 sWhere = Left(sWhere, Len(sWhere) - 4)

The error message I get is

 Public ReadOnly Property Length() As Integer' has no parameters and its return type cannot be indexed.

 

[ZmrAbdulla]

sWhere = str.Substring(0, str.Length(sWhere) - 4)

________________________________________________________
Zameer Abdulla
Help to find Missing people

 

[ribbons]

Thanks!

But . . . I'm still getting the same error.

'Public ReadOnly Property Length() As Integer' has no parameters and its return type cannot be indexed.

 

[ZmrAbdulla]

oops..

sWhere = str.Substring(0, str.Length - 4)

________________________________________________________
Zameer Abdulla
Help to find Missing people

 

[ribbons]

Thanks bunches!!