Combining queries

D

doenka

I want to update a column with a update query, the type of the field is text
and I want to change a .(dot) into :. If I run the query I get no result. It
should not be that difficult. What am I doing wrong
 
M

MGFoster

doenka said:
I want to update a column with a update query, the type of the field is text
and I want to change a .(dot) into :. If I run the query I get no result. It
should not be that difficult. What am I doing wrong
Click to expand...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Who knows, you haven't shown your query.

Have you tried using the Replace() function?

UPDATE table
SET column_name = Replace(column_name, ".", ":")
WHERE <criteria>
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBR765eYechKqOuFEgEQIJNQCfV726b36q+NLGUXLJyYfam2PgLwMAnjTv
kgIFslkUB2UpcO+fTU+5x3o3
=+0g8
-----END PGP SIGNATURE-----
 

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

Combine Duplicates in Query 0
Combine results using query 4
update query based on two fields 4
Can a Table be Updated From a Subquery with Aggregate Count Value? 6
Combining queries that don't match 0
DSum update query with multiple fields 0
Crosstab Combinations 4
Update primary key field with multiple "where" clauses 0

Top