Sql Equivalent to PADL() in SQL 2000

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Sql Equivalent to PADL() in SQL 2000

Message

From

07/09/2006 18:45:52

Sergey Berezniker
New York, United States

07/09/2006 16:29:19

Tc Holzer
Isle of Man

General information

Forum:

Visual FoxPro

Category:

Databases,Tables, Views, Indexing and SQL syntax

Title:

Re: Sql Equivalent to PADL() in SQL 2000

Environment versions

Visual FoxPro:

VFP 9

OS:

Windows XP SP2

Network:

Windows 2003 Server

Database:

MS SQL Server

Miscellaneous

Thread ID:

01152075

Message ID:

01152131

Views:

This message has been marked as a message which has helped to the initial question of the thread.

Hi Tracy,

SELECT * FROM mytable 
  ORDER BY mytable.myfield, RIGHT(REPLICATE('0',15) + mytable.myfield2,15)

You may find http://fox.wikis.com/wc.dll?Wiki~VFPSQL-TSQL-Mapping usefull.

>Nevermind, LPAD.
>
>
>Anyone know the equivalent to PADL() in SQL?
>
>E.g.:
>
>SELECT * FROM mytable ORDER BY mytable.myfield, PADL(mytable.myfield2,15,'0')

--sb--

Map

View

Click here to load this message in the networking platform