# Re: 如何去除SQL字串中的空白呢?

Posted by james chen on September 29, 1998 at 11:15:32:

In Reply to: 如何去除SQL字串中的空白呢? posted by meteor on September 29, 1998 at 11:06:54:

: 如我的栏位的资料为 "A BFD DSAF" 那我该用SQL的那个函数去除空白呢?
: 因RTRIM()及LTRIM()只是去除左右的空白,请各位帮帮忙吧!
------------------------
我的作法是 栏位的资料为 "A BFD DSAF"
dim v_str as string
v_str=t_space(field_name) 't_space is function 自己写
sql="....""" & v_str & """ "

Follow Ups: