c*t
2 楼
Microsoft Access Help:
Find or replace a value in a field
【在 s*******n 的大作中提到】
: 有任何idea都可以
:
: 中
Find or replace a value in a field
【在 s*******n 的大作中提到】
: 有任何idea都可以
:
: 中
s*n
3 楼
Thank you! But it's not that simple. The data in this column has all kinds of
format like ABC 0, DEF 1, GH 123, IJKL123.... I think there should be some
kind of IIF statement to judge if I met a space or numerical symbol to remove
from the data. But I don't know how to write this SQL. HELP!!
除其
【在 c**t 的大作中提到】
: Microsoft Access Help:
: Find or replace a value in a field
format like ABC 0, DEF 1, GH 123, IJKL123.... I think there should be some
kind of IIF statement to judge if I met a space or numerical symbol to remove
from the data. But I don't know how to write this SQL. HELP!!
除其
【在 c**t 的大作中提到】
: Microsoft Access Help:
: Find or replace a value in a field
c*t
4 楼
You may use DBI + perl to do; or you need create function.
【在 s*******n 的大作中提到】
: Thank you! But it's not that simple. The data in this column has all kinds of
: format like ABC 0, DEF 1, GH 123, IJKL123.... I think there should be some
: kind of IIF statement to judge if I met a space or numerical symbol to remove
: from the data. But I don't know how to write this SQL. HELP!!
:
: 除其
【在 s*******n 的大作中提到】
: Thank you! But it's not that simple. The data in this column has all kinds of
: format like ABC 0, DEF 1, GH 123, IJKL123.... I think there should be some
: kind of IIF statement to judge if I met a space or numerical symbol to remove
: from the data. But I don't know how to write this SQL. HELP!!
:
: 除其
r*y
5 楼
用VBA写一段代码，用SQL取出来，处理了再用SQL写回去。很简单。
【在 s*******n 的大作中提到】
: 有任何idea都可以
:
: 中
【在 s*******n 的大作中提到】
: 有任何idea都可以
:
: 中
s*n
6 楼
Could you help me with the code? I'm not familiar with VBA. Thanks a lot!
除其
【在 r****y 的大作中提到】
: 用VBA写一段代码，用SQL取出来，处理了再用SQL写回去。很简单。
除其
【在 r****y 的大作中提到】
: 用VBA写一段代码，用SQL取出来，处理了再用SQL写回去。很简单。
q*a
7 楼
这个用excel做简单些吧。我想
【在 s*******n 的大作中提到】
: Thank you! But it's not that simple. The data in this column has all kinds of
: format like ABC 0, DEF 1, GH 123, IJKL123.... I think there should be some
: kind of IIF statement to judge if I met a space or numerical symbol to remove
: from the data. But I don't know how to write this SQL. HELP!!
:
: 除其
【在 s*******n 的大作中提到】
: Thank you! But it's not that simple. The data in this column has all kinds of
: format like ABC 0, DEF 1, GH 123, IJKL123.... I think there should be some
: kind of IIF statement to judge if I met a space or numerical symbol to remove
: from the data. But I don't know how to write this SQL. HELP!!
:
: 除其
相关阅读
help: SQL Server数据同步复制One question on SQL Server求救!!! 一个oracle的问题! 在procedure中所涉及的表名可以用变量从参数中传入吗recursive sql?has anyone used jConnect with Sybase?About write/read binary files in PBSQL Server 2000: When? how to particially delete record in sql server --- there is no field for autonumber请推荐一本Database的好书.how to write this query, need help !!oracle dbms_output怎样实现WWW Client的安全登录？用Servlet显示数据库里的数据,分页的? (很实际的问题)who has registration code for toad?Managment server in Oracle8iquestionhow to register SQL Server in intranetRe: question about CAST and Multisethelp and questionsHelp!-VB-Addnew?