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!!
:
: 除其
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! about recover Sysdba ID& passwordModel Questionmy TOAD expiredstored procedure 菜鸟一问, PLEASE HELP,在线等[转载] How to check disk size for / directory??How to creat user in Oracle?stored procedure help Please.....关于数据库格式互换,求教!What are two methods of retrieving SQL?地地道道的新手求助about installation of oracle9i求教how to get all numerical data?請推荐一款笔记本電腦请问, oracleform有没有必要考一个ORACLE证?[转载] Re: 如何调试这个ASP程序?Oracle DBA Handbook 8i & 9i 区别有多大?请教一个ACCESS的土问题Help!! MS Access's database project