1. 论坛系统升级为Xenforo，欢迎大家测试！
    Dismiss Notice

SQL 2000 查询语句中能否直接截取制定长度文本？

Discussion in '网站运营' started by Ulysses, Oct 11, 2006.

  1. Ulysses

    Ulysses New Member

    Joined:
    Feb 5, 2006
    Messages:
    10,018
    Likes Received:
    16
    例如 ntext 类型的字段，想直接取出前 100 个字符，SQL 中是否有直接可以使用的函数？

    查了一下没找到。

    ;)
     
    #1 Ulysses, Oct 11, 2006
  2. Ulysses

    Ulysses New Member

    Joined:
    Feb 5, 2006
    Messages:
    10,018
    Likes Received:
    16
    原来 SUBSTRING 就可以。

    :D
     
    #2 Ulysses, Oct 11, 2006
(You must log in or sign up to post here.)
Toggle Width
Language
English (US)