append command

[rotschreck]

I no longer have access to my Oracle for Win95 but i need some of it's programing for my access database...<br>
<br>
I believe I remember an append command. I need to know if I can use this command to append text in 2 fields or more to make 1 field.<br>
<br>
EG<br>
<br>
append field1 field2;<br>
<br>
<br>
gives:<br>
<br>
field1field2<br>
<br>
is this right?<br>
<br>
thanks <p> <br><a href=mailto: > </a><br><a href=

http://www.geocities.com/siltharin>Rotschrck's

Eclectic Page</a><br>

 

[carp]

I believe you're thinking of the concat function:<br>
<br>
concat(field1,field2) returns field1field2<br>
<br>
You can also use double verticals:<br>
<br>
field1¦¦field2 yields field1field2<br>
<br>
I'm not sure if either of these methods are standard SQL (I believe concat is). However, even if they are, that still doesn't mean it will work in Access. Best bet is to try it and see what happens!