i have onre table in which i want to create id as SO-001,SO-002 and so on....and ii want to use it as foriegn key in details table..so how i can create int in sql server r2 2008 thanking you