Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2002
    Posts
    192

    Unanswered: T-SQL Mid() function

    Is there an T-SQL equivalent to Mid() in Access SQL?

  2. #2
    Join Date
    Oct 2002
    Posts
    369

    Post Re: T-SQL Mid() function

    Originally posted by access_dude
    Q1 Is there an T-SQL equivalent to Mid() in Access SQL?
    A1 Yes. Substring will probably meet your needs:

    Select Substring('some Char Data. Example 2.', 6, 10)

    Character String Functions:
    Ascii
    Char
    Charindex
    Difference
    Left
    Len
    Lower
    Ltrim
    Nchar
    Patindex
    Quotename
    Replace
    Replicate
    Reverse
    Right
    Rtrim
    Soundex
    Space
    Str
    Stuff
    Substring
    Unicode
    Upper

Posting Permissions

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