Space before character - SQL Server Forums

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)

Space before character

Author

Topic

sanjay5219
Posting Yak Master

240 Posts

Posted - 2009-09-25 : 06:48:26

Dear All,

I am having value 8:00PM, i want to write update statement which should make this 8:00 PM.

Please help

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-09-25 : 07:02:28

What is the datatype of the column?


Update table
set col=replace(col,'PM',' PM')

Madhivanan

Failing to plan is Planning to fail

sanjay5219
Posting Yak Master

240 Posts

Posted - 2009-09-25 : 07:03:23

Datatype is nvarchar

sanjay5219
Posting Yak Master

240 Posts

Posted - 2009-09-25 : 07:06:10

thanks

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources