SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 RPAD similar function in T-SQL
 New Topic  Reply to Topic
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 2

jamie
Aged Yak Warrior

542 Posts

Posted - 06/03/2005 :  06:10:41  Show Profile  Reply with Quote
thank you for all the help.
this is now working perfectly.
and suprisingly quick !
you are right Rob, I doubt I'll be using CONVERT functions to tidy up data before exporting now !
Go to Top of Page

Igor2004
More clever than you

Canada
78 Posts

Posted - 06/14/2005 :  00:57:40  Show Profile  Visit Igor2004's Homepage  Reply with Quote
to robvolk
The plan is rather simple to create the name having written the good functions benefitting.
To receive time to time such letters
-------------------------------------------

To Igor Nikiforov,

Thank you for sharing your code. I Googled 'SQL count occurrence of
character in a string' and bingo! Didn't have to write it and got so
much more.

Appreciate it.

Phil Youker
Programmer/Analyst
VCSSO/Information Technology Services
-------------------------------------------
to not hammer in forums any nonsense
to give efficient advice , for instance
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49733
Question: "is there a similar function in SQL server to ORACLES RPAD ?"
I do not speak English also I am don't the MVP, but the question is clear enough.
IMHO the answer is rather simple "Yes, see http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,54,33,27115"
But it appears it is possible to write about bcp etc .
Go to Top of Page

DonAtWork
Flowing Fount of Yak Knowledge

2161 Posts

Posted - 06/14/2005 :  07:44:45  Show Profile  Reply with Quote
Igor: Here on these forums, we do not JUST answer the question. We try to make sure that the person is asking the RIGHT question to begin with. Just because something works, does not mean that it is the ONLY answer, or the correct one. You can use a sledgehammer to drive in a carpet tack, but it is not the right tool.

*need more coffee*
SELECT * FROM Users WHERE CLUE > 0
(0 row(s) affected)
Go to Top of Page

robvolk
Most Valuable Yak

USA
15676 Posts

Posted - 06/14/2005 :  08:27:53  Show Profile  Visit robvolk's Homepage  Reply with Quote
Don-

Even though you're 100% right, you're interrupting Igor's cross-posting self-love fest. The point of this thread is no longer to provide a solution, but to celebrate his clever string functions that you have to visit his web site to see.

And don't worry, he's got a very clever sproc to drive carpet tacks, and several appreciative letters from carpetlayers across the world.

Go to Top of Page

Merkin
Funky Drop Bear Fearing SQL Dude!

Australia
4970 Posts

Posted - 06/14/2005 :  08:31:32  Show Profile  Visit Merkin's Homepage  Reply with Quote
Apologies to rrb...


there once was a clever string function
that came to be hyperlinked with gumption
it was linked too often
by a self proclaimed boffin
who's translation was not fit for consumption





Damian
"A foolish consistency is the hobgoblin of little minds." - Emerson
Go to Top of Page

jsmith8858
Dr. Cross Join

USA
7423 Posts

Posted - 06/14/2005 :  08:42:07  Show Profile  Visit jsmith8858's Homepage  Reply with Quote
Well done, Damian!

- Jeff
Go to Top of Page

Igor2004
More clever than you

Canada
78 Posts

Posted - 06/14/2005 :  11:50:21  Show Profile  Visit Igor2004's Homepage  Reply with Quote
to DonAtWork
Clearly, on a question full and useful answers have been given many.
For example, the passer-by in the street will ask you " What time is it ? " you will start to specify, time in what point of the Earth interests the passer-by,
robvolk will tell as to make a sundial :-), discussion will begin.

to robvolk
I'm sorry, I have posted in this topic by mistake instead of http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=50673&whichpage=2,
I have not guessed to remove. Now to delete late.
"his clever string functions " - It is a fair estimation, every day 20-30 person downloads my functions, they share your opinion.
"to visit his web site to see" - Unfortunately it isn't my site, originally I have placed the functions there, the site have precise statistics.
to Merkin
Thanks for your opinion. I'm sorry, I don't speak english. Let me now please can I post your opinion in page
http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,54,33,27115
Any opinion is positive or negative is valuable to me.
For instance,
"there once was a clever string function
that came to be hyperlinked with gumption
it was linked too often
by a self proclaimed boffin
who's translation was not fit for consumption
Damian, Sydney, Australia"
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Previous Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.12 seconds. Powered By: Snitz Forums 2000