help need - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

help need

help need# Database - 数据库

w*i2099-12-10 08:12

1 楼

should be very simple, but need your help...
a very big string, more than 255 chars.
i am using SQL server 6.5, and varchar()
can not hold more than 255 chars in 6.5
version (in 7.0, it can hold 8000 chars)
So, i am trying to use 'text' instead
of 'varchar'. however, i can't find
any useful function to operate on
big 'text' string(such as @xxxx), seems
all text function works for tables'
column.
anybody can help me? Great thanks..

w*i2099-12-10 08:12

2 楼

actually, i just wanna know the functions
that can do
'patindex(), substring(), STUFF(), ltrim()'
for 'text', instead of 'varchar'.
please note it is SQL 6.5
thankssss

【在 w*i 的大作中提到】

: should be very simple, but need your help...
: a very big string, more than 255 chars.
: i am using SQL server 6.5, and varchar()
: can not hold more than 255 chars in 6.5
: version (in 7.0, it can hold 8000 chars)
: So, i am trying to use 'text' instead
: of 'varchar'. however, i can't find
: any useful function to operate on
: big 'text' string(such as @xxxx), seems
: all text function works for tables'

w*h2099-12-10 08:12

3 楼

You want to do it in VBScript?
Why not convert it to string? CStr(...)

【在 w*i 的大作中提到】

w*i2099-12-10 08:12

4 楼

VBSCRIPT？ NO NO， IT IS JUST A SMALL
PROBLEM IN MICROSOFT SQL-SERVER 6。5
STRING CAN HOLD 255 CHAR， BUT I NEED
A VERY BIG STRING， THAT MUST BE HELD
IN TEXT。 BUT I CAN‘T FIND ANY USEFUL
FUNCTIONS FOR TEXT。：-(

【在 w*****h 的大作中提到】

: You want to do it in VBScript?
: Why not convert it to string? CStr(...)