SQL 2005 syntax for VFP PADR and PADL

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

SQL 2005 syntax for VFP PADR and PADL

Message

From

02/03/2006 12:28:40

James Blackburn
Qualty Design Systems, Inc.
Kuna, Idaho, United States

02/03/2006 12:22:39

Evan Delay
Vancouver, British Columbia, Canada

General information

Forum:

Microsoft SQL Server

Category:

SQL syntax

Title:

Re: SQL 2005 syntax for VFP PADR and PADL

Environment versions

SQL Server:

SQL Server 2005

Miscellaneous

Thread ID:

01100959

Message ID:

01100964

Views:

Evan,

Take a look at Message #997657

>Is there a SQL Server equivalent for the FoxPro PADR() and PADL() functions. These function pad a string either to the left or right up to a specified number of characters. In this case I'm only concerned with padding with spaces.
>
>BTW, thanks to those building this page
>http://fox.wikis.com/wc.dll?Wiki~VFPSQL-TSQL-Mapping

Map

View

Click here to load this message in the networking platform