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
	String concatenation operator in Sybase T-SQL	Joshi	0	159	02-03-2010 11:06 PM Last Post: Joshi
	Java and SQL user-defined functions in Sybase ASE	crazYoga	0	121	02-02-2010 02:26 AM Last Post: crazYoga
	REPLACE function [String] in Sybase Adaptive Server(ASE)	crazYoga	0	163	02-02-2010 02:18 AM Last Post: crazYoga
	SQL to Replace String in Sybase	john	0	355	12-09-2009 05:15 PM Last Post: john
	ltrim and rtrim functions in sybase	Joshi	0	210	09-09-2009 01:51 AM Last Post: Joshi
	Replace string in Sybase	Joshi	0	79	09-09-2009 01:49 AM Last Post: Joshi
	Sybase User defined SQL functions	zaadmin	0	211	11-10-2008 11:19 PM Last Post: zaadmin
	Sybase Cursors - Overview ,Explanation and Examples	sybaseadmin	0	1,872	10-21-2008 03:46 PM Last Post: sybaseadmin
	T-SQL: A Simple Way to Build a String from a Column	zaadmin	0	143	10-10-2008 09:50 PM Last Post: zaadmin