Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2003
    Location
    Colombo, Sri Lanka
    Posts
    6

    Question Unanswered: Equivilent Of SQL Server LEFT Function

    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.

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780

    Re: Equivilent Of SQL Server LEFT Function

    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.

  3. #3
    Join Date
    Jun 2003
    Location
    Colombo, Sri Lanka
    Posts
    6

    Thumbs up

    Thanks. That works a treat

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •