How to retrieve the max character on a text field?

Question

Post reply

How to retrieve the max character on a text field?

SQL ORACLE

One Orange Chip

Points: 27807
More actions
September 6, 2011 at 10:04 am

#247583

Many thanks in advance?

Viewing 6 posts - 1 through 5 (of 5 total)

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

Lowell SSC Guru Points: 323518 More actions · Answer 1

SQL ORACLE (9/6/2011)
Many thanks in advance?

by max character you mean the highest ASCII value? like 'A' = 65 and 'a' =97?

so the highest "char" in 'bananas' is 's' with an ascii of 115?

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

SQL ORACLE One Orange Chip Points: 27807 More actions · Answer 2

I mean max number of characters in a text data type field.

Lowell SSC Guru Points: 323518 More actions · Answer 3

you can use the LEN() or DATALENGTH() functions:

SELECT max(DATALENGTH(TheTextField)) As MaxDataLength FROM

TheTable

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

SQL ORACLE One Orange Chip Points: 27807 More actions · Answer 4

SQL ORACLE

One Orange Chip

Points: 27807

September 6, 2011 at 10:20 am

#1377557

It works. Many thanks again.

Sean Lange SSC Guru Points: 286590 More actions · Answer 5

fyi, the text and ntext datatypes are deprecated. You should instead use varchar(max) or nvarchar(max).

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/