Threaded Mode | Linear Mode

john · 07-07-2009, 02:30 AM

plus sign (+) concatenation 'one'+'two'='onetwo'
ascii char->ascii value ascii('A')=65
char ascii->char char(65)='A'
charindex similar to instring charindex('two','onetwothree')=4
char_length length of string charlength('onetwo')=6
lower lower case lower('ONE')='one'
ltrim trim left blanks ltrim(' one')='one'
replicate repeat chars replicate('-',8)='--------'
reverse flip string reverse('salad')='dalas'
right right chunk of string right('Chicago',2)='go'
rtrim trim right blanks rtrim('test ')='test'
space spaces space(5)=' '
str float->char str(5.6,12,2)=' 5.60'
stuff insert chars within str stuff('onetwothree',4,3,'-----')='one-----three'
substring get piece of string substring('sybase',1,2)='sy'
upper upper case upper('one')='ONE'

Possibly Related Threads...
Thread:		Author	Replies:	Views:	Last Post
	Need help in converting String to Date format	surbhit4u	0	206	06-22-2010 01:05 PM Last Post: surbhit4u
	String concatenation operator in Sybase T-SQL	Joshi	0	751	02-03-2010 11:06 PM Last Post: Joshi
	Java and SQL user-defined functions in Sybase ASE	crazYoga	0	308	02-02-2010 02:26 AM Last Post: crazYoga
	REPLACE function [String] in Sybase Adaptive Server(ASE)	crazYoga	0	725	02-02-2010 02:18 AM Last Post: crazYoga
	SQL to Replace String in Sybase	john	0	1,913	12-09-2009 05:15 PM Last Post: john
	ltrim and rtrim functions in sybase	Joshi	0	597	09-09-2009 01:51 AM Last Post: Joshi
	Replace string in Sybase	Joshi	0	195	09-09-2009 01:49 AM Last Post: Joshi
	Sybase User defined SQL functions	zaadmin	0	419	11-10-2008 11:19 PM Last Post: zaadmin
	Sybase Cursors - Overview ,Explanation and Examples	sybaseadmin	0	3,457	10-21-2008 03:46 PM Last Post: sybaseadmin
	T-SQL: A Simple Way to Build a String from a Column	zaadmin	0	266	10-10-2008 09:50 PM Last Post: zaadmin