Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using VarChar

Status
Not open for further replies.
jamz

jamz

Technical User
Sep 25, 2002
3
AU
Hello, I am using SQL Server 2000 and I am trying to combine 2 columns that are defined as varchar(255) to 1 column defined as varchar(7000). I know SQL Server 2000 allows you to have a varchar defined at 7000 but when I run my query it cuts off the new column at 256 characters. Is there a setting within SQL Server 2000 that I am missing?
 
Sort by date Sort by votes
I've only used SQL 7, but what are you viewing the new field with? If it's query analyser you'll have to change the max length per field shown. codestorm
 
Upvote 0 Downvote
Thanks! Codestorm, that was it.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

dgillz
  • Locked
  • Question
How to convert varchar to time? 2
Replies
1
Views
1K
Chris Miller
Chris Miller
elly00
  • Locked
  • Question
create sql view using batch file
Replies
5
Views
822
Mike Lewis
Mike Lewis
Auguy
  • Locked
  • Question
Using UDF In Select, Bad Idea? 2
Replies
3
Views
460
Auguy
Auguy
grnzbra
  • Locked
  • Question
205 Characters from VARCHAR(200) Field?
Replies
2
Views
300
grnzbra
grnzbra
Niki_S
  • Locked
  • Question
Create view using two databases
Replies
4
Views
502
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top