Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SELECT command
Message
From
16/04/2000 15:31:36
 
 
To
16/04/2000 11:50:21
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00360123
Message ID:
00360154
Views:
9
>Now the problem with this is it will retrieve '011' or '0122' or wherever is after that. I don't want that. I only want the value of '01'
>What function can I use to do this? Or how can I say that in my SELECT?

I dunno how SQL Server works really, but if its anything like FoxPro, try padding the property with spaces:

padr(Thisform.MyProperty, 7)
Previous
Reply
Map
View

Click here to load this message in the networking platform