WCS

SELECT * FROM USERS ORDER BY   CASE when REGISTRATION is null then 1 else 0 end, REGISTRATION DESC 

<wcpgl:widgetImport useIBMContextInSeparatedEnv="${isStoreServer}" url="${env_customSiteWidgetsDir}com.sonepar.commerce.store.widgets.PaymentMethods/PaymentMethods.jsp">                   <wcpgl:param name="storeId" value="${WCParam.storeId}"/> <wcpgl:param name="catalogId" value="${WCParam.catalogId}"/>                     <wcpgl:param name="langId" value="${langId}"/>                      <wcpgl:param name="orderId" value="${currentOrderId}"/>                     <wcpgl:param name="type" value="add"/>                     <wcpgl:param name="ShippingPage" value="true"/>                     <wcpgl:param name="returnView" value="OrderShippingBillingView"/>                     <wcpgl:param name="fromShippin