To register for an Internet.com membership to receive newsletters and white papers, use the Register button ABOVE.
To participate in the message forums BELOW, click here

HOME News MS SQL Oracle DB2 Access MySQL PHP Scripts Books Links DBA Talk


Go Back   Database Journal Forums > Related Sites > SQL Course
Reload this Page

Replicate

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

SQL Course SQL Course > Ask questions about the lessons on SQL Course 1 and 2. If you have problems > with the interface, please post in the Feedback forum

Reply Post New Thread
 
Thread Tools Search this Thread Rate Thread Display Modes
  #1  
Old 12-11-2002, 02:45 AM
klries klries is offline
Junior Member
  
Join Date: Dec 2002
Posts: 1
Replicate
I need to find the next Id to be used in an order and pad a 0 to the front..

I know that I can select the max(strIid)+1 and get the next orderid. How do I use the Replicate function to add a leading zero to the id which is a varchar(5)?
Reply With Quote
  #2  
Old 12-13-2002, 10:17 AM
skhanal skhanal is offline
Experts
  
Join Date: Nov 2002
Location: New Jersey, USA
Posts: 3,369
You can do this

SELECT REPLICATE('0', 5 - DATALENGTH(cast(StrIid as char(5)))) + ltrim(cast(StrIid as char(5)))
FROM table
Reply With Quote
Reply Post New Thread

« Previous Thread | Next Thread »
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Linear Mode Linear Mode
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT -5. The time now is 05:15 AM.

DatabaseJournal Recent Articles

 » Preparing To Upgrade Access Tables to SQL ...

 » Microsoft Windows PowerShell and SQL Serve...

 » New MySQL Enterprise with Query Analyzer B...

 » Quest Software Strengthens Committment to ...

 » Oracle Unveils New Event-Driven Middleware...

Search Database Journal:
 


Contact Us - Database Journal Forums - Top



Acceptable Use Policy

JupiterOnlineMedia

internet.comearthweb.comDevx.commediabistro.comGraphics.com

Search:

Jupitermedia Corporation has two divisions: Jupiterimages and JupiterOnlineMedia

Jupitermedia Corporate Info


Legal Notices, Licensing, Reprints, & Permissions, Privacy Policy.

Web Hosting | Newsletters | Tech Jobs | Shopping | E-mail Offers
Powered by vBulletin® Version 3.7.4
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.