I want to do: SELECT approved

[nationavon]

I want to do:

SELECT approved_by||'|'||request_date from ATABLE where this="that"

It is possible with Oracle but I get the following in access:

Invalid use of vertical bars in query expression

This would allow me to select data which is separated by a pipe.

Any help would be greatly appreciated!

 

[THoey]

I ran the following query and it worked:

SQLWKS> select '*' || '|' || '*'
2> from dual
3>
'*'
---
*|*
1 row selected.

Is that the exact query you ran or an example? Terry M. Hoey
th3856@txmail.sbc.com
While I don't mind e-mail messages, please post all questions in these forums for the benefit of all members.

 

[nationavon]

I even tried:

SELECT 'approved_by'||'|'||'request_date' from ATABLE where this="that"

as displayed in your example and I still get:

Invalid use of vertical bars in query expression '*'||'|'||'*''

This would allow me to separate the table data with a | so that I could split it back out later with perl.

 

[THoey]

Try this:

SELECT approved_by & '|' & request_date
from ATABLE
where this="that"

Sorry, missed the "in Access" part...

Terry M. Hoey
th3856@txmail.sbc.com
While I don't mind e-mail messages, please post all questions in these forums for the benefit of all members.

 

[Guest_imported]

How can I search for records with wilcard and limit them for those with 7 digits only. For example if I have these records in table1:
13035551212
1212555
140455512125
and I run this SQL statement:
select * from table1 where column1 like '1%%%%%%'

only record 1212555 should have been returned.

Can any one help me to correct the statement

 

[tlbroadbent]

Select * From Tbl
Where col1 Like "1*"
And len(col1)=7 Terry

http://members.home.net/tlbroadbent/prog.htm

The reason why worry kills more people than work is that more people worry than work. - Robert Frost