Substring

  • Thread starter Thread starter Guy Cohen
  • Start date Start date
G

Guy Cohen

Hi all.
I am using VB6 + ADO 2.7 + ACCESS2000 MDB.
How do I use substring ?
I tried:
--
SELECT MobileNumber AS [Mobile number],
SUBSTRING(DestinationNumber,1,10)
AS [Destination number]
FROM tblCallsLog
--
And got RTE 80004005, Method Open of object _Recordset failed.

Please advise :(

TIA
Guy
 
Hi all.
I am using VB6 + ADO 2.7 + ACCESS2000 MDB.
How do I use substring ?
I tried:
--
SELECT MobileNumber AS [Mobile number],
SUBSTRING(DestinationNumber,1,10)
AS [Destination number]
FROM tblCallsLog
Click to expand...

Use Mid() in place of Substring()
 
SUBSTRING is SQL SERVER T-SQL whilst for Access you can use MID$ function.

Chris.


Hi all.
I am using VB6 + ADO 2.7 + ACCESS2000 MDB.
How do I use substring ?
I tried:
--
SELECT MobileNumber AS [Mobile number],
SUBSTRING(DestinationNumber,1,10)
AS [Destination number]
FROM tblCallsLog
--
And got RTE 80004005, Method Open of object _Recordset failed.

Please advise :(

TIA
Guy
 
Back
Top