Easy Update

can someone please enlighten me. why doesn't this work? It is supposed
to remove any periods in the TSUSA_Code field.
UPDATE tblLookupParts
SET TSUSA_Code = REPLACE(TSUSA_Code, '.', '')
thanks
-doodle
I am getting: Undefined function 'Replace' in expression.
|||Is it because you have a case sensitive collation?
You can find this using Select SERVERPROPERTY('Collation')...
doodle wrote:
> can someone please enlighten me. why doesn't this work? It is supposed
> to remove any periods in the TSUSA_Code field.
> UPDATE tblLookupParts
> SET TSUSA_Code = REPLACE(TSUSA_Code, '.', '')
>
> thanks
> -doodle
|||that returns an error also: unable to parse query text
|||You are running Microsoft SQL Server, are you not? What version and
service pack level?
Roy
On 20 Oct 2006 15:07:49 -0700, "doodle" <ADraughn@.mazakcorp.com>
wrote:

>can someone please enlighten me. why doesn't this work? It is supposed
>to remove any periods in the TSUSA_Code field.
>UPDATE tblLookupParts
>SET TSUSA_Code = REPLACE(TSUSA_Code, '.', '')
>
>thanks
>-doodle
|||I have SQL Server 2005, using Visual Studio 2005 to run my SQL queries
against Access DB tables.
-doodle
|||On 21 Oct 2006 05:44:05 -0700, "doodle" <ADraughn@.mazakcorp.com>
wrote:

>I have SQL Server 2005, using Visual Studio 2005 to run my SQL queries
>against Access DB tables.
>-doodle
That explains it. You need to use Access's dialect of SQL. Look for
help in an Access newsgroup.
http://groups.google.com/groups/dir?...06877&expand=1
Roy Harvey
Beacon Falls, CT