w*i
发帖数: 63 | 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*i
发帖数: 63 | 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*****h
发帖数: 139 | 3 You want to do it in VBScript?
Why not convert it to string? CStr(...)
【在 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*i
发帖数: 63 | 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(...)
|
|
