Question Concatenation in MS Access 2007

[arpitraval]

i have a list of the 5000 users whose email addresses are firstname.lastname@yahoo.com and now i want to convert it to firstname.lastname@sify.com so please let me know if there is any option of doing it through query design otherwise its pain to do it manually.

I have seen the concatenation in which we can connect two different name but what if i want to disconnect something.

 

[pbaldy]

You could use the Replace function to replace @Yahoo with @sify.

 

[arpitraval]

can you show me by writing the code which i need to put in the query.

Thanks for your quick reply.

 

[arpitraval]

Thanks

Thanks for your reply but can you show me by writing in the coding manner that how to write it in to the query.

 

[pbaldy]

Why don't you look in Help at the replace function and give a whirl. If you get stuck, post the SQL of your query and I'll fix it.

 

[arpitraval]

Replace

I am not a regular user of Database. And i am not using SQL coding. i am using MS ACCESS. and was talking about the query in ACCESS where we can do the same thing as replace.

 

[pbaldy]

So was I; you can switch a query from design view to SQL view. In design view:

NewField: Replace(...)

 

[arpitraval]

Replace Function

Thanks very much.
I got it. Thats new for me.

 

[pbaldy]

Excellent. Just wanted to make sure you realize that doesn't actually change the data. If you want to do that, you can use the same function in an update query. In SQL view, that would look like:

UPDATE TableName
SET FieldName = Replace(...)

 

[arpitraval]

Will ask few question in future

Hi,

As i told you that i am new to this field, so can i ask you silly questions like Replace function!!!!

Thanks
Arpit Raval