Hiding first number of characters.

S.Vinothkumar · #1 09-25-2007, 09:59 PM

Hi all,

I want to hide the first number of character in a string.

For ex,

If the string is i_%dvinoth, suppose I want's to get vinoth only from that string,how could from SQL server?

leoraja8 · #2 09-27-2007, 12:08 AM

Hey Vino!

Use my coding...

Code:

SELECT REPLACE('i_%dvinoth', LEFT('i_%dvinoth',4),'')

leoraja8 · #3 09-27-2007, 12:23 AM

Vinoth,

You can use the another way as following,

Code:

SELECT stuff('i_%dvinoth',1,4,'')

Murali · #4 09-27-2007, 02:18 AM

Hi,

May be this ... a common one to be used in ORACLE, MYSQL and SQL SERVER.

Code:

SELECT SUBSTR('i_%dvinoth',5);

S.Vinothkumar · #5 09-28-2007, 06:37 AM

Hi there,

Thank you all....

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Showing n Hiding DIV LAYER through JAVSCRIPT?	laksh_khamesra	Web Design Help	1	09-09-2008 08:10 PM
Substituting Characters using different databases	srikumar_l	Database Support	1	12-05-2007 06:33 AM
Substituting Characters using different databases	srikumar_l	Database Support	1	12-04-2007 12:56 AM
How to Get the Right Characters of a string in sql server?	kingmaker	Database Support	3	08-01-2007 08:07 AM
What's the easiest way to remove characters from the end of a string in php?	oxygen	PHP Programming	1	07-26-2007 01:53 AM