sql server - Query to find zip codes with ending '0000' -

-

i need find zip codes in database end '0000'. using below query, able return zip codes 9 digits in length. how add return zipcodes have 9 digits in length , have 0000? i'm sure it's simple i'm still new querying. :)

example: 922340000

select addresszipcode dbo.cr_member_allmemberdetails len(addresszipcode) = 9 

select addresszipcode dbo.cr_member_allmemberdetails len(addresszipcode) = 9 , addresszipcode '%0000'

Comments

Post a Comment

Popular posts from this blog

python - TypeError: start must be a integer -

-
i trying draw 5 turtles, getting typeerror on line 25. here code: import turtle wn = turtle.screen() redrose = turtle.turtle() color = input("what background color be?") fillcolor_f = input("what color of rose be?") redrose.hideturtle() redrose.speed(30) redrose.penup() redrose.left(180) redrose.forward(175) redrose.right(90) redrose.forward(30) redrose.right(90) redrose.pendown() def drawrose(red): redrose.color("pink") redrose.fillcolor(fillcolor_f) redrose.fill(true) in range(red): redrose.forward(i) redrose.right(49) in range(5): drawrose(redrose) redrose.penup() redrose.forward(350) redrose.right(144) redrose.pendown() redrose.fill(false) drawrose(50) wn.bgcolor(color) i trying draw 5 roses, produces errors. doing in interactivepython.org. you recursively calling drawrose wrong parameter. on line 23 ( for in range(red): ) expect red integer...
Read more

html - How can i make an element from a bottom stacking context stays in front of another higher stacking context? -

-
Image
this question has answer here: override css z-index stacking context 1 answer how can make element contained in stacking context @ bottom of stacking order appears in front of element in different stacking context higher in stacking order ? e.g: html: <div class="parent-1"></div> <div class="parent-2"> <div class="pepe"></div> <div class="pepin"></div> </div> css: .parent-1{ position: absolute; z-index: 10; background-color: green; } .parent-2 { position: absolute; z-index: 5; background-color: red; } .pepe, .pepin{ background-color: blue; } .pepin{ position: fixed; z-index: 100; } this have (this it's suppose happen): this want: bare in mind can't change elemnts order in html neither remove z-index ...
Read more

sql - MySQL Custom calculate views -

-
i having difficulty trying combine set of queries using. having execute multiple queries different years , cid numbers. (cid 1-5, years currentyear currentyear-6) current sql statement: select 1 cid, 2015 `year`, ( select sum( legacy_reports_payments.amountpaid ) * -1 payments legacy_reports_payments datepaid >= "2015-01-01 00:00:00" , datepaid < "2015-02-01 00:00:00" , cid = 1) paymentsjan, ( select sum( legacy_reports_payments.amountpaid ) * -1 payments legacy_reports_payments datepaid >= "2015-02-01 00:00:00" , datepaid < "2015-03-01 00:00:00" , cid = 1) paymentsfeb, ( select sum( legacy_reports_payments.amountpaid ) * -1 payments legacy_reports_payments datepaid >= "2015-03-01 00:00:00" , datepaid < "2015-04-01 00:00:00" , cid= 1) paymentsmar, ... this returns: cid | year | paymentsjan | paymentsfeb | ... 1 | 2015 | 3000.00 | 3000.00 | ...
Read more