Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
PADL() equivalent in SQL Server
Message
 
 
To
10/04/2003 11:16:10
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00776019
Message ID:
00776104
Views:
28
>>Try to cust it to character type
SELECT CAST(REPLACE(STR(MONTH(AddDate),2), ' ', '0') AS char(2))
>
>Same thing

Strange, it returns 2 character field (not memo) for me.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform