SQL Server Forums

Home | Weblogs | Forums | SQL Server Links

Active Forum Topics | Popular Articles | All Articles by Tag | SQL Server Books | About

SQL Server Forums

Register Now and get your question answered!

Username:	Password:
Save Password
Forgot your Password?

All Forums

Old Forums

CLOSED - General SQL Server

function

Forum Locked

Printer Friendly

Author

Topic

mateenmohd
Constraint Violating Yak Guru

United Arab Emirates
297 Posts

Posted - 05/26/2007 : 09:57:27

what function will use to add P in the user_id data ?

user_id type varchar

ie.
user_id
--------
012345
014153
016464
...

add P before the user_id i.e.

user_id
--------
p012345
p014153
p016464
...

regards
Mateen

spirit1
Cybernetic Yak Master

Slovenia
11741 Posts

Posted - 05/26/2007 : 10:34:11

update YourTabel
set user_id = 'p' + user_id

if this causes a truncation of some data you'll have to increase the column length first.

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

madhivanan
Premature Yak Congratulator

India
22469 Posts

Posted - 05/26/2007 : 10:40:25

Alternatively, you can add that when selecting data

Select 'p'+user_id as user_id from table

Madhivanan

Failing to plan is Planning to fail

mateenmohd
Constraint Violating Yak Guru

United Arab Emirates
297 Posts

Posted - 05/26/2007 : 10:43:07

thanks you very much.

Topic

Forum Locked

Printer Friendly

Jump To:

SQL Server Forums

This page was generated in 0.05 seconds.