column data moving one character to another column

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

column data moving one character to another column

Author

Topic

maheedhar
Starting Member

2 Posts

Posted - 2012-02-21 : 00:31:30

Hi All,

I am getting one problem in sql server. I have sql server out with data. but data is moving from character to another column.

Here i have query

Data

First Name LastName

Maheedhar venkata
John Abraham

here the problem

First Name(Column1) LastName(Column2)

Maheedha rvenkata
Joh nAbraham

from Firstname data one character is moving to another column lastname.

This is the problem i am getting. Pls suggest solution for me.

Thanks in Advance

Maheedhar

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2012-02-21 : 06:57:47

This could be an artifact of the way you are querying or it could be that the data indeed got messed up somehow. Just select only first name or only last name and see if you get the right data.

SELECT FIRSTNAME FROM YOUR TABLE;

If that seems ok, the problem is in the way your are presenting the data. If even that seems incorrect, then somehow your data got corrupted.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources