|
Home > Archive > MS SQL Server > October 2006 > Easy Update
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| doodle 2006-10-24, 6:38 pm |
| 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
| |
| doodle 2006-10-24, 6:38 pm |
| I am getting: Undefined function 'Replace' in expression.
| |
|
| Is it because you have a case sensitive collation?
You can find this using Select SERVERPROPERTY('Coll
ation')...
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
| |
| doodle 2006-10-24, 6:38 pm |
| that returns an error also: unable to parse query text
| |
| Roy Harvey 2006-10-24, 6:38 pm |
| 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
|
|
|
|
|