Re: How to edit data

#1

You might check the character length once the data is replaced. If it is
not working, it's a bug. This is typical for values that are too long.
Remember that characters can be spaces as well. If you simply append, for
instance, a single character onto an existing single character value (in a
char 2 typed data field) there is actually a space character still in
there. So, if you hit enter, you will get the error you saw previously.
If you hit delete right after the character yo typed in, it will delete the
space and the value will be entered.
--------------------

Quote:

Reply-To: "Andrew J. Kelly" <sqlmvpnooospam (AT) shadhawk (DOT) com
From: "Andrew J. Kelly" <sqlmvpnooospam (AT) shadhawk (DOT) com
References: <VIXUa.24174$Mc.1879121 (AT) newsread1 (DOT) prod.itd.earthlink.net
Subject: Re: How to edit data
Date: Sun, 27 Jul 2003 19:01:11 -0400
Lines: 33
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <#bH#4LJVDHA.656 (AT) tk2msftngp13 (DOT) phx.gbl
Newsgroups: microsoft.public.sqlserver.tools
NNTP-Posting-Host: h002078c8df25.ne.client2.attbi.com 24.128.54.36
Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftn gp13.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.tools:18981
X-Tomcat-NG: microsoft.public.sqlserver.tools

I agree with Ray that you should create an UPDATE statement to do the
work.
Sounds like a simple REPLACE is what your after. You can find out more
in
BooksOnLine on the topic. If you need further help with the statement
just
give us some more info and someone will gladly assist you.

--

Andrew J. Kelly
SQL Server MVP

"StuTheDog" <stuthedog (AT) msn (DOT) com> wrote in message
news:VIXUa.24174$Mc.1879121 (AT) newsread1 (DOT) prod.itd.earthlink.net...
This is really stupid I know b/c it doesn't appear to be documented
anywhere
but I'm new to MSSQL which is why I'm flustered: I need to edit the
data
in
a column, I'd like to simply bring up Enterprise Mgr, open the table
then
walk down the column I'm interested in, making my edits. I keep
getting
"The value you entered is not consistent iwth the data type or length
of
the
column." Help says it's b/c I entered an wrong data type but that's
not
it.
I have a field of type char, I'm simply inserted a single character or
2
within the existing data. If I do a full field replace the data is
replaced, the problem only occurs if I try to insert a character or 2.
Pressing F2 to get into edit mode doesn't help. What's up?

Stu

This posting is provided "AS IS" with no warranties, and confers no rights

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: How to edit data

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools

Re: How to edit data - 08-19-2003 , 02:47 PM