Replace chars

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steve. - 11 May 2005 15:01 GMT

I am trying to replace chars in field without replacing all the chars. I
have a field called in Member TBL called MbrName with a value of BFL####. I
need to run a query that promps for a user number and have the #### replaced
with the user number entered. I can only get the entire value replaced.
help!

Reply to this Message

Chaim - 11 May 2005 16:06 GMT

Steve,

Is 'BFL' part of every MbrName value (interesting name for a field that is
clearly not a member name)? Why not simply catenate 'BFL' to the beginning of
the number in the update (presumably) SQL. Like:

update MemberTBL set MbrName = "BFL" & Str([What's the number? ])
where <whatever the criteria are to limit the update to this
single record>;

Or am I completely missing your problem here?

> I am trying to replace chars in field without replacing all the chars. I
> have a field called in Member TBL called MbrName with a value of BFL####. I
> need to run a query that promps for a user number and have the #### replaced
> with the user number entered. I can only get the entire value replaced.
> help!

Reply to this Message

Steve. - 11 May 2005 17:53 GMT

Sorry I wasnt so clear. The MbrName field will have many different members
that will have #### in then name that will need to be replaced with the user
number entered. I have created a standard Table of members that will be
loaded to a second table after the update is applied. It's basically a model
list that the user imports into prod table.

> Steve,
>
[quoted text clipped - 13 lines]
> > with the user number entered. I can only get the entire value replaced.
> > help!

Reply to this Message

Andre Laplume - 11 May 2005 16:23 GMT

This should work...

Create an Update Query and drop down MbrName. Under the condition put:
LEFT([MbrName],3) = "BFL"

Under Update put: "BFL" & [Enter the new number]

It should change any member number staring with: BFL to BFL + the number
you enter.

Reply to this Message