how convert nvarcar to int

Question

how convert nvarcar to int

hoseini_akram

SSC Enthusiast

Points: 139
More actions
October 4, 2012 at 10:43 pm

#282695

hello
Sorry, I'm Convert one of the fields of Table Nvarchar(10) to integers
Please help me

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 1

hoseini_akram (10/4/2012)
hello
Sorry, I'm Convert one of the fields of Table Nvarchar(10) to integers
Please help me

If you are having problems doing this, it's because the column contains data which cannot be converted to an int. It's easier for us if we can see what you can see -

we need some sample data. Can you provide some?

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden