Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select memo as char
Message
From
17/03/2004 23:01:06
Sergey Berezniker
New York, United States
 
 
To
17/03/2004 22:57:34
Ramil Alcano
Areté, Inc.
Pennington, New Jersey, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Select memo as char
Miscellaneous
Thread ID:
00887390
Message ID:
00887392
Views:
11
This message has been marked as the solution to the initial question of the thread.
>Hi all,
>
>Is it possible to SELECT myField, substr(myMemo,1,254) as myChar from myTable?

Yes, but you would use PADR() function because SUBSTR() doesn't guaranty the size of the field.
SELECT myField, PADR(myMemo,254) as myChar from myTable
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform