Equivilent Of SQL Server LEFT Function

Shandy · #1 (**permalink**) 10-09-03, 07:42

Does the equivilent of a LEFT function in SQL Server exist in Informix? I am trying to perform the following statement:
DELETE FROM tctstam WHERE LEFT(Style, 1) = 'O'
i.e. delete all records from the tctstam table where the first character of the Style field is a 'O' character.
I am using VB/ADO/ODBC to perform the delete.

gurey · #2 (**permalink**) 10-09-03, 09:34

Quote:

Originally posted by Shandy
Does the equivilent of a LEFT function in SQL Server exist in Informix? I am trying to perform the following statement:
DELETE FROM tctstam WHERE LEFT(Style, 1) = 'O'
i.e. delete all records from the tctstam table where the first character of the Style field is a 'O' character.
I am using VB/ADO/ODBC to perform the delete.

Hi,

Depending on Informix version it's exist, now test with

DELETE FROM tctstam WHERE Style[1, 1] = 'O'

Gustavo.