SpanExluding equivalent for SQL?

Ask a Question related to Coldfusion Database Access, Design and Development.

  1. #1

    Default SpanExluding equivalent for SQL?

    as the subject states, is there something similar to spanexcluding() that i can
    use in an sql statement? (ms sql 2k)

    i want to try taking a price and changing the cents...so the value 123.45
    would be changed to 123.99

    thanks in advance!

    tragik Guest

  2. Similar Questions and Discussions

    1. Equivalent of GetVersionInfo ()
      Hi, Is there a way to get the information returned by the VC++ fn GetVersionInfo( ); thru any of the perl structures / commands ? PS : If this...
    2. PHP equivalent to MOD
      Hi, I need to see if a number is divisible by 2. I don't see the math function "mod" in my PHP Functions reference manual. Is there another way...
    3. php equivalent of CGI.pm
      I'm translating several old cgi scripts (that use CGI.pm) to php. CGI.pm has a series of conventient function calls for generating HTML code on the...
    4. C's static equivalent
      Hi! Is there something similar to C's static keyword? I want a single function, which has to access and modify a permanent variable. Any...
    5. ACT! Equivalent for Mac?
      Does anyone know if there is a Macintosh program whose features are roughly equivalent? This PC software runs on VPC, but is fairly sluggish....
  3. #2

    Default Re: SpanExcluding equivalent for SQL?

    No. You would write a simple SQL UDF for this.
    MikerRoo Guest

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139