Friday, June 11, 2004
Padding with 0's infront, to make same length digits (using SQL)
1) MS Access try this
2) MS SQL Server try this
3) IMB DB2 the keyword you've gotta look up is DIGITS (then use SUBSTR).
What DIGITS does is that it returns a character string representation of its argument. you can use DIGITS to given you a string something like this '000000002'(assuming current number we are working on is 2)
Then you have to use SUBSTR to pull out the last 3 digits(if you are trying to pad to 3 digits)
There ya go its all set!Cheers!
Tuesday, June 08, 2004
Forgot that ConnectionString?
Good MSDN Enterprise Software Layering example
Free ASP.NET Web hosting
Friday, June 04, 2004
Hillsongs in Singapore
Thursday, June 03, 2004
Fun facts for VS.NET 2003
Using pic. HTML table background info
Found out something i didnt know about tables and their background images.. below is a section i copied from http://www.workz.com/
At first glance, this is the obvious method. However, use it only if the vast majority of your visitors use Explorer (in a company Intranet, for example). In Netscape, your table display will be a mess. Yes, it will catch the eye - but for the wrong reason.