Insert a character into a string

G

Guest

Hello,
I need to insert a hyphen into a text field (Field1) in a table.
For example, the data for Field1 = "1234567". I want to insert a hyphen
after the 3rd character, so Field1 = "123-4567". Is there a built-in function
in Access 2000? Any help is very much appreciated.
 
M

Marshall Barton

Samantha said:
I need to insert a hyphen into a text field (Field1) in a table.
For example, the data for Field1 = "1234567". I want to insert a hyphen
after the 3rd character, so Field1 = "123-4567". Is there a built-in function
in Access 2000? Any help is very much appreciated.
Click to expand...

Not that I know of, but you can use an expression in a query
field:

IIf(Mid(field1, 4, 1) <> "-", Left(field1, 3) & "-" &
Mid(field1, 4), field1)
 
G

Guest

It works! thank you so much!.

Marshall Barton said:
Not that I know of, but you can use an expression in a query
field:

IIf(Mid(field1, 4, 1) <> "-", Left(field1, 3) & "-" &
Mid(field1, 4), field1)
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL String being cut off 3
Button to insert boilerplate text into field in a parent form 9
how does the INSERT INTO SQL work?? 2
Inserting a hyphen after the 3rd character 3
Insert into with table and values 2
concatenation 3
create string from column data 6
Basic setting form filter criter from text box 2

Top