Featured post

c# - Usage of Server Side Controls in MVC Frame work -

i using asp.net 4.0 , mvc 2.0 web application. project requiremrnt have use server side control in application not possibl in noraml case. ideally want use adrotator control , datalist control. i saw few samples , references in codepleax mvc controllib howwver found less useful. can tell how utilize theese controls in asp.net application along mvc. note: please provide functionalities related adrotator , datalist controls not equivalent functionalities thanks in advace. mvc pages not use normal .net solution makes use of normal .net components impossible. a normal .net page use event driven solution call different methods service side mvc use actions , view completly different way handle things. also, mvc not use viewstate normal .net controlls require. found article discussing mixing of normal .net , mvc.

sql - Problems with case-when-value-between something -formula -


i have case in have product codes, 4 symbol long. in cases products same no mather of first symbol, example 1 product code 7456 , 8456 , these products still have same function. difference first symbol , 3 symbols rigth remains same.

my problem compare 2 data table each other , in first table used code 7456 , in second 1 code 8456. mach these 2 data dunno know how tell sql if code start 7 or 8 use 3 last symbols.

i think possible solution kind of case when value between 7000-8999 use 3 right, can't code work? has solution me??? thanks!

are looking this

case     when value between '7000' , '8999'         right(value, 3)     else value end 

Comments

Popular posts from this blog

c# - Usage of Server Side Controls in MVC Frame work -

cocoa - Nesting arrays into NSDictionary object (Objective-C) -

ios - Very simple iPhone App crashes on UILabel settext -