sqlfzk
Last Activity: Apr 25 '13, 10:20 PM
Joined: Feb 19 '13
Location:
-
how can I do it? I want to create a report that shows only names more than 25 characters. -
using where clause to find Len of a column that has less than a number
my table has a columnn 'name', I want to find only the name are more than 25 characters; I did this, but it doesn't work; can anybody help me with that. thanks;
where max(len(ltrim(r trim(name)))) > 25 -
oops, thanks for you info.Leave a comment:
-
multiple case inside of each other
Hi, how I can create a column with case when I need another case in "then"; here is my problem: fyi, tyear is 4 diget and year is 2 diget; what I'm doing wrong?
...Code:[Year]= case when isnull(t.status,'') <> 4 then case when rigth(t.[Year],2)< rigth(t.[tYear],2) then when t.[Year] <= 12 then '20'+t.[Year] else '19'+t.[Year] end else t.[tYear] end from
No activity results to display
Leave a comment: