insert a single character (-) in a string

[DaveT99]

I would like to insert a (-) after the 4th character. My query SQL is



SELECT Master_MPN.Std_MPN, Master_MPN.Std_Part_Desc, Master_MPN.Std_Mfr
FROM Master_MPN
WHERE (((Master_MPN.Std_Part_Desc) Like "*PHOTO*") AND ((Master_MPN.Std_Mfr) Like "SICK*"));

the field requiring the inserted character is Master_MPN.Std_MPN

Many Thanks
dave

[Welshgasman]

Use Left() and Mid() functions?

[ranman256]

=left([field],4) & "-" & mid([field],5)

[DaveT99]

Many thanks Ranman256, worked perfectly
Tks Again for the quick reply
Dave