[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 139
  • Last Modified:

Sql Server 2012 table wont accept certain letters

I have a table in Sql Server 2012.  One of the fields in the table is a varchar(50)
This table has about 25,000 records in it and works just fine. Except that the field will not allow the letters SK to be the first two letters in the field. Anything else works fine, but when a word starting with "Sk" is entered, it times out and will not allow the data to be saved.
Any ideas?
0
LearningToProgram
Asked:
LearningToProgram
3 Solutions
 
Dave BaldwinFixer of ProblemsCommented:
It may appear that way but I'm certain that isn't all there is to it because Sql Server just doesn't work that way.  Do you have any stored procedures working on the data?  Any filtering being done to it first?
0
 
Patrick MatthewsCommented:
Or adding to Dave's comments, are you sure there aren't any constraints?
0
 
PortletPaulCommented:
What is the relevance of Excel to this question?

What is timing out exactly? (Excel?, a web form?)
0
 
LearningToProgramAuthor Commented:
There were no constraints, stored procedures or filters. I created a new table and moved the data over and that fixed it.
0
 
LearningToProgramAuthor Commented:
There were no constraints, stored procedures or filters. I created a new table and moved the data over and that fixed it.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now