Arejae.Com

CHARINDEX and PATINDEX functions return the starting position of a pattern you specify. PATINDEX can use wildcard characters while CHARINDEX cannot.
Imagine you have a BoxNo field with below values in your table.
BoxNo
——
BOX1
BOX3
BOX4
BOX30
BOX123
Using MS-SQL syntax,You will have a few options to separate those values into number.
1.)
select BoxNo,substring(BoxNo,CHARINDEX(’X’,BoxNo)+1,len(BoxNo)) as No from #temp
2.)
select BoxNo,replace(BoxNo,’BOX’,”) as No from #temp
You [...]

I have been working on Data Warehousing in the Insurance Company for quite some time. Since 2001 to be exact. ETL is part of data warehouse component. My Introduction post about ETL is somewhere in 2006. Since then, so many things happened. I resign and come back again to the same company,doing the same [...]

Some of my friends asking about how to reveal protected access file (.mdb) due to some reasons, hence I write this post to help them.
Here you go.
Description
===========
This utility reveals the database password of every password-protected mdb file that created with Microsoft Access 95/97/2000/XP or with Jet Database Engine 3.0/4.0 .
It can be very [...]

Can you guess which one is a max number if the data type for the field is not an integer ? perhaps it is varchar or nvarchar field.

10
1
2
3
14
15
9
8

The answer is 9. I believe it is because ascii value for 9 = 57 and the ascii value for 25 = 50

Then, how you want to get [...]

DBDesigner4 from fabFORCE.net, is a nice FREE tool for data modelling that I use for quite some time.

DBDesigner 4 compares to products like Oracle’s Designer©, IBM’s Rational Rose©, Computer Associates’s ERwin© and theKompany’s DataArchitect© but is an Open Source Project available for Microsoft Windows© 2k/XP and Linux KDE/Gnome. It is release on the GPL.

I like [...]