Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Setting the size for fields in select statement
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Setting the size for fields in select statement
Miscellaneous
Thread ID:
00649677
Message ID:
00649696
Views:
6
>You can use PADR() function.
select PADR(transform(nvl(field1,"nothing")) + ;
>              transform(nvl(field2,"either")), 32) ;
>  from x
>

Thanks, Sergey! :)
Like Frank said: "I did it... MY WAY!"
Previous
Reply
Map
View

Click here to load this message in the networking platform