Results 1 to 3 of 3
  1. #1
    Join Date
    May 2003
    Posts
    144

    Unanswered: Substr or Mid in adp?

    I am trying to break a string into 3 sections. For example, 11112222333 needs to be 1111-2222-333. Since it is a adp, SQL server does not take substr and mid. Does anybody has any idea what command should I use?

    Thanks

    SHK

  2. #2
    Join Date
    Feb 2004
    Posts
    199
    Syntax
    SUBSTRING ( expression , start , length )

    Syntax
    LEFT ( character_expression , integer_expression )
    MDB, ADP <-> MS SQL + VBA, ADO & RDO, .NET, Oracle, Java/Jsp.

  3. #3
    Join Date
    May 2003
    Posts
    144
    Thanks!

Posting Permissions

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