Skip to main content

Problem And Solutions

Search This Blog

Instr function for MSQL query

on May 04, 2011

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

SELECT PATINDEX('%-%', field2check)

Eg:
if want to find the position of the '-' in categorycode - '2001-01'
SELECT PATINDEX('%-%', '2001-01')

Return value :5

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

Comments

Popular Posts

Bing ...........

www.bing.com is Microsoft 's new online portal , the next generation of Windows Live Search Engine. Bing's search capability is sensitive to the type of information being searched for and brings up information on the search results that is more relevant. The Bing search page is attractive and graphical, and it calls out the vertical search types with which it excels via a list of links. One of the big draws here is that complex searches—where you're shopping for a particular product or trying to book a trip, for example—can take place entirely within the confines of Bing. So rather than click in and out of a Spartan list of links, you can instead do research in-place. Bing's travel experience is particularly well designed and is integrated with the price-forecasting capabilities of the Microsoft FareCast service. Likewise, the shopping experience integrates with Microsoft's Cash Back technology, so your PayPal account will automatically be credited if you buy via a

IssueManager

IssueManager is a web-based solution for tracking issues, bugs and tasks in your organization. It's extremely useful in software development but also any project that involves team of two or more people. The application is currently used in thousands of companies and corporations, small and large. Version 3.0 is a complete rewrite of the application using new object-oriented approach for better reliability, security and robustness. UltraApps team has also included few additional features to make IssueManager even more functional, easy to use and good-looking. Simple, yet powerful, IssueManager features: Secure, multi-level web access via login authentication Issue assignment by person, priority and status Full text search Comprehensive, sortable issue grid with summary by status Bookmarks for rapid access to commonly used queries Issue history tracking - each response is individually tracked Issue file attachment support Single click export of selected records to MS Excel Color

VB Script to show Expiration Date in BGInfo

'======================================== ' First, get the domain policy. '======================================== Dim oDomain Dim oUser Dim warningDays warningDays = 30 Set LoginInfo = CreateObject("ADSystemInfo") Set objUser = GetObject("LDAP://" & LoginInfo.UserName & "") strDomainDN = UCase(LoginInfo.DomainDNSName) strUserDN = LoginInfo.UserName Set oDomain = GetObject("LDAP://" & strDomainDN) '======================================== ' Determine the last time that the user ' changed his or her password. '======================================== Set oUser = GetObject("LDAP://" & strUserDN) 'intUAC = oUser.Get("userAccountControl") '======================================== ' Add the number of days to the last time ' the password was set. '======================================== whenPasswordExpires = DateAdd("d", 180, oUser.

Powered by Blogger