how to run a substring query in ACCESS?

[ja]

Hello,

I am trying to combine/substring parts of three different fields into
one. For example, in sql, the syntax is as follows:

Once the extra field has been added to the table,

update xtable
set field1 = substring(field2, 1, 5) + substring(field3, 1, 5) +
substring(field4, 1, 10)

In paradox in objectpal:
tc1.field1=substr(tc1.field2,1,5)+substr(tc1.field 3,1,5)+substr(tc1.field4,1,10)

How can this be done in Access? I've been looking at the help online.
No luck so far.

ms access 2002

TIA

[MGFoster]

Use the Mid() function: same parameters as substring().

Instead of the + symbol use the & symbol to concatenate the strings.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

ja wrote:

Hello,

I am trying to combine/substring parts of three different fields into
one. For example, in sql, the syntax is as follows:

Once the extra field has been added to the table,

update xtable
set field1 = substring(field2, 1, 5) + substring(field3, 1, 5) +
substring(field4, 1, 10)

In paradox in objectpal:
tc1.field1=substr(tc1.field2,1,5)+substr(tc1.field 3,1,5)+substr(tc1.field4,1,10)

How can this be done in Access? I've been looking at the help online.
No luck so far.

ms access 2002

[ja]

thank you.
On Thu, 05 May 2005 18:44:34 GMT, MGFoster <[e-mail]> wrote:

Use the Mid() function: same parameters as substring().

Instead of the + symbol use the & symbol to concatenate the strings.