skip to main | skip to sidebar

Code.NET

Tuesday, May 20, 2008

SQL search on float value, using string wild cards

Do convert the float value to bigint and then to nvarchar to search using wild cards and like
e.g
CONVERT(nvarchar, CONVERT(bigint, ))

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Favourite Websites

  • wakoopa
  • Simpsonize You
  • odetocode.com
  • Lifehack

Blog Archive

  • ►  2015 (2)
    • ►  April (1)
    • ►  February (1)
  • ►  2014 (1)
    • ►  July (1)
  • ►  2010 (2)
    • ►  March (1)
    • ►  January (1)
  • ►  2009 (8)
    • ►  November (1)
    • ►  October (3)
    • ►  July (1)
    • ►  January (3)
  • ▼  2008 (17)
    • ►  September (1)
    • ▼  May (2)
      • I am feeling.....
      • SQL search on float value, using string wild cards
    • ►  April (3)
    • ►  March (2)
    • ►  February (2)
    • ►  January (7)
  • ►  2007 (16)
    • ►  December (1)
    • ►  November (1)
    • ►  October (2)
    • ►  September (7)
    • ►  July (2)
    • ►  June (3)
Feedback