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!!
:
: 除其
相关阅读
Suffix tree and the matrix together?helpIs there any small free database support Java ?how to update oracle view by delphiHelp on JDBC:ODBC SOScan .pc and .c make difference?请问有关在NT下运行VB的水晶报表 foxporany good textbook about DBMS?给偶一个干活的机会,何如? 申请作Database板副Another onedata warehouse[转载] Whcich DB Software to Install?encryptionhelp!how to enlarge the size of master device!what about oracle,repository&service?how to usa mSQL?Looking for ODBC Resouces --- New Standard?how to do a case insensitive comparisonA web based database adm program