tsql - Transact Sql LEFT function weird output -

- 

select replace(stuff('123456',2,2,'abcd'),'1',' ')  select left('abcd456',4)  select left(replace(stuff('123456',2,2,'abcd'),'1',' '),4)

ok first select outputs 'abcd456', series of functions evaluates first parameter left function in second select second select returns 'abcd' expected third select returns 'abc'

why? shouldn't output 'abcd'? know? in advance.

it clearer if do

select '[' + left(replace(stuff('123456',2,2,'abcd'),'1',' '),4) + ']'

which returns

[ abc]

there leading space!

select stuff('123456',2,2,'abcd') gives 1abcd456

then replace 1 space


Comments

Post a Comment

Popular posts from this blog

windows - Why does Vista not allow creation of shortcuts to "Programs" on a NonAdmin account? Not supposed to install apps from NonAdmin account? -

-
i'm working on installer (using wise installer, older version 1999). i'm creating shortcut in programs group exe. i'm creating shortcut on desktop. if install run admin account, create shortcut on common desktop , common program group (i.e., read hkey_local_machine\explorer\shellfor users). if it's installed nonadmin account, install hkey_current_user's desktop , program group. behavior install on: xp nonadmin - desktop , program shortcuts install ok. vista admin - desktop & program shortcuts install ok. vista non-admin, uac off - desktop shortcut installs, program shortcut not . however, program group folder they're supposed installed does created. at end of install, launch program group has shorcut. launches in of above. can manually drag shortcut folder , works fine. i'm bloody baffled. i've tried installing other commercial apps (opera, foxit, firefox) firefox install under nonadmin (and if select other program files,...
Read more

visual studio - Deleting lines of code in a text editor -

-
edit: question had been tagged "tolstoy" in appreciation of quality , length of writing:) reading first , last paragraph should enough:) if tend select , move code mouse, stuff in middle interesting you. this question how use text editors in general. i’m looking best way delete plurality of lines of code (no intent patent it:) extends transposing lines, i.e. deleting , adding them somewhere else. importantly, don’t want creating blank lines have delete separately. sort of visual studio's shift+delete feature, working multiple lines @ once. say want delete line 3 following code (tabs , newlines visualized well). naïve way select text between angle brackets: if (true) {\n \t int = 1;\n \t <i *= 2;>\n \t += 3;\n }\n then hit backspace. creates blank line. hit backspace twice more delete \t , \n. you end with: if (true) {\n \t int = 1;\n \t += 3;\n }\n when try select whole line, visual studio doesn't let select trailing newline character. ex...
Read more

What's the encoding type of Android 2.2 push message? -

-
i'm studying android push service (c2dm) android froyo version. google says max size of message 1024 bytes ( http://code.google.com/intl/ko/android/c2dm/ ). message encoding type? want put message not english. c2dm requires application send messages url-encoded content type application/x-www-form-urlencoded . can confirm works data german umlauts + ß.
Read more