ICPooreman
asked on
problem with sql query left(colname,length)
I'm trying to use left(colname,length) in a query like below
Select *
From TableName
Where left(colName,6) = '10003-'
I keep getting the error when I try to execute
Invalid use of Keyword
left(colName,6)
I'm using a DBase table with BDE any ideas why I can't execute this query?
Select *
From TableName
Where left(colName,6) = '10003-'
I keep getting the error when I try to execute
Invalid use of Keyword
left(colName,6)
I'm using a DBase table with BDE any ideas why I can't execute this query?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.