how can execute this query..?

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

My query is

SQL

UPDATE EMPLOYEE_MASTER SET ADDRESS='anyone',CITY= 'anyone',STATE= 'Andaman and Nicobar (UT)',ZIPCODE= '123456' WHERE LOGIN_NAME='xyz'

now problem is when STATE='Andaman and Nicobar (UT)' it can not execute,
but when STATE='Andaman Nicobar (UT)' it can execute...
Here how can i update as STATE='Andaman and Nicobar (UT)'

Posted 21-Dec-11 18:41pm

jasmin_patel

Updated 21-Dec-11 18:48pm

Suresh Suthar

v2

Add a Solution

Comments

uspatel 22-Dec-11 1:01am

any error message?

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Suresh Suthar · Accepted Answer · 2011-12-21T18:50:00

Solution 1

What error you are getting?
First check your column length of State field. IMO its less than 20 and you are passing value that's length is 24.

Posted 21-Dec-11 18:50pm

Suresh Suthar

Comments

thatraja 22-Dec-11 0:52am

Possible case, 5!

jasmin_patel 22-Dec-11 1:00am

thanks it's right..
my columns length is 20.

thank you once again.

member60 22-Dec-11 1:02am

My 5!

Tanveer A · Accepted Answer · 2011-12-21T18:53:00

Solution 2

check your column length of state column this should increase
your query is ok

Posted 21-Dec-11 18:53pm

Tanveer A

uspatel · Accepted Answer · 2011-12-21T19:01:00

Solution 3

Check your column size.
Your query is right.

Posted 21-Dec-11 19:01pm

uspatel

Sachin Suryawanshi · Accepted Answer · 2011-12-21T20:08:00

Solution 4

There is no problem in your query..

Just check the length of column..

Posted 21-Dec-11 20:08pm

Sachin Suryawanshi