Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Insert-SQL pads fields with spaces...
Message
From
19/01/1999 09:55:55
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Insert-SQL pads fields with spaces...
Miscellaneous
Thread ID:
00177560
Message ID:
00177560
Views:
67
I need to insert "CERT" into a field that is 10 characters long on a sysbase database engine. I can't allow spaces to pad out the field, or another application will refuse to see the record. This DOESN'T work:

insert into master_cred (system_name) values ("CERT")

That will pad with spaces. What do I need to do?

Thanks! :-)
--Todd Sherman
-Wake Up! Smell the Coffee!
Next
Reply
Map
View

Click here to load this message in the networking platform