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!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Space() function
- Thread starter balves
- Start date
tlbroadbent
MIS
You should be able to use at least 7999. I ran this query in SQL 7.
Select Len(space(7999)+'|')
It returned the following.
-----------
8000
(1 row(s) affected)
When I ran Select Len(Space(8000)), the result was 0. I'm not sure if that occurred because of the limit of the Space function or if SQL trimmed the output. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.
- Status
Similar threads